D
Darin Kramer
Howdie...
I have a cell that is validated, allowing user a choice of one of three
items. I have then written a macro to do something if he chooses option
1.
How do I get the Macro to run automatically when the user chooses the
option?
(I have tried referencing another cell with IF statemnts to get the
right answer, but still doesnt launch the macro)
Effectively I need to tell Excel to check the result of a cell every
time a choice is made in the valiation box....
Any ideas most welcome...
Regards
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I have a cell that is validated, allowing user a choice of one of three
items. I have then written a macro to do something if he chooses option
1.
How do I get the Macro to run automatically when the user chooses the
option?
(I have tried referencing another cell with IF statemnts to get the
right answer, but still doesnt launch the macro)
Effectively I need to tell Excel to check the result of a cell every
time a choice is made in the valiation box....
Any ideas most welcome...
Regards
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!