Mattie Owens
asked on
Run Macro from Content Control Drop Down List in Microsoft Word
Microsoft Word VBA
I'd like to run a macro based on the selection from a control content drop down list. Is this possible.
If not, how do I copy the content to another cell, and maybe run the macro based on the new cell value.
I'd like to run a macro based on the selection from a control content drop down list. Is this possible.
If not, how do I copy the content to another cell, and maybe run the macro based on the new cell value.
ASKER
Its a couple
If its orange run macro 1
if its blue run macro 2
if its green run macro 3
else do nothing
If its orange run macro 1
if its blue run macro 2
if its green run macro 3
else do nothing
ASKER
is it possible
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I determine what the control number is? Do I place the code in a regular module
ASKER
Okay it works except that it runs before I even make a selection
Are you saying that you want the macro to start when you have changed the selection?
ASKER
Once I understood it. It worked perfectly.
Is it one macro that is executed when the selection changes or are there multiple macros and you want to determine which to call/run based on what's been selected?