I am trying to call a Sub based on the value of a drop down list. I have created all of the individual subs for each of the different values in the drop down list and saved them in the Modules. I have run each of the Module subs and they work correctly. I created the following event trigger sub and placed it in Sheet1 under objects. When I change the values on the drop down list nothing happens. Any ideas?
Please Login or Register to view this content.
Last edited by AliGW; 10-15-2018 at 10:05 AM.
Welcome to the foums!
Please take a look at the second of our forum rules regarding code tags, which you will need to add yourself in future. I will do it for you this time. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That is not a valid event, unless you have declared your own event?
Everyone who confuses correlation and causation ends up dead.
I'm new to this. Please help me understand what you mean by this is not a valid event.
I meant that worksheet events have very specific names and signatures. For a worksheet_change event, which I suspect this needs to be, you have to call it Worksheet_Change:
or it will not respond to changes on the worksheet.Please Login or Register to view this content.
When I read the code from the internet I just assumed that was a sub name that I could call whatever I want. That fixed it. Thank you for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks