I am trying to have three actions (separate macros) to run based on a control button so that firstly select from the named drop down list, then push the control button linked to a macro which will look at the named selection and then based upon that selection run the associated macro.
My drop down list is in a cell named "Choice", the data validation options are "First", "Second" and "Third" and the associated actions/macros are simply colour cell background, insert some simple text and put a border around cell.
The names of the macros are Background, Text and Border again respectively.
I have tried the following code with no success and would warmly welcome benefiting from the knowledge and experience of this forum
Many thanks
Macro select based on Drop Down Selection
-
-
Re: Macro select based on Drop Down Selection
QuoteI have tried the following code with no success
What exactly is it that you're having an issue with? Also please remember to use code tags - if you are unsure then please ask.
-
Re: Macro select based on Drop Down Selection
The macros don't operate, I suspect my coding / naming is incorrect?
-
-
-
-
Re: Macro select based on Drop Down Selection
Pike you're a legend, both have functionality I was looking for - many thanks, you're a legend.
-
Re: Macro select based on Drop Down Selection
Pike
I'm not sure how to advise "solved", any advice? -
Re: Macro select based on Drop Down Selection
no need to here .. thanks for the acknowledgment it helped
only kiwis I don't help here if they are Richie Mc and Quade C
-
Re: Macro select based on Drop Down Selection
Not sure if Quade qualifies as a Kiwi!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!