I'm trying to trigger one of three Macros based on the value of the dropdown selected from a validation list. But the Macros are not firing on using the Worksheet_Change event (which I have coded into the Worksheet module it is to be active in). Folloing is the code I'm writing...where am I going wrong? B10 is the cell that has the Validation list
Please Login or Register to view this content.
I've had the same problem. My workaround is to put a formula that refers to the validated cells (like =COUNTA(1:65536)) in an inconspicous cell and use the Calculate event.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
The below works for me. Have you tried to make the Target.Value = string?
Try alsoPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by MarvinP; 11-06-2010 at 10:19 PM. Reason: New Idea
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks