#1
|
|||
|
|||
Activating or decativating Cell
Hi Guys,
Can someone suggest me how to activate or decativate the cell based on the value of some other cell. Regards Umesh Banga |
#2
|
||||
|
||||
This can be done using VBA. But what is the purpose of this and how will the value of the other cell change (would a user manually change it or does it contain a formula)?
|
#3
|
|||
|
|||
Hi,
The values will change manually. for example, if the there is a question - "how many funds the user has", and the answer to that is 3 - then it should activate three particular cells in a specific section. hope it clarifies. Regards Umesh Banga |
#4
|
||||
|
||||
Okay sure. In this case, what does 'activate' mean? Do they change colour, become selected, or something else? I think if you attach an example workbook then we should be able to come up with an answer quite quickly.
|
#5
|
|||
|
|||
Hi,
sorry do not have sheet yet. cells can change color or become selected. and it should be must for user to enter the information. if he does not excel should through a warning message or direct the user to fill in that particular cell. hope this helps. |
#6
|
|||
|
|||
any reply?
|
#7
|
||||
|
||||
Until you have an actual workbook to work with, all that can be given is advice on hypothetical situations. It's rathe hard to code for that, especially when you're not clear on whether/why the cells need to be activated, change colour, etc.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Activating Signature on an ad hoc basis | HowardC | Outlook | 2 | 03-13-2012 09:20 AM |
help activating office | JamiEngland | Office | 1 | 01-26-2012 09:47 PM |
Activating the OutLook Social Connector in OutLook 2010 | balubeto | Outlook | 1 | 01-17-2011 12:06 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |