OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

empty cells every time another cell is changed

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
anil11
General User
General User


Joined: 28 May 2012
Posts: 7

PostPosted: Tue Jun 05, 2012 7:33 am    Post subject: empty cells every time another cell is changed Reply with quote

hi,
could you pls help me write a macro for the following scenario:
C14 has data validation (e.g. A, B, C, D).
Every time a user chooses from the list in C14, cells C20, 23 and 26 are emptied.
thanks! Smile
Back to top
View user's profile Send private message
CSLam
General User
General User


Joined: 08 Aug 2012
Posts: 29
Location: Hong Kong

PostPosted: Thu Aug 30, 2012 6:54 pm    Post subject: Reply with quote

Not sure what exactly is needed. If "emptied" refers to "nothing shown in the cell", no marco is needed :-

=IF(ISBLANK(C14);xxxxxx;"")

where xxxxxx is what originally exists in the cell.

CSLam
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group