How do I make a macro call on different macros

[Guest]

I am stuck. I can not find this problem is help.
I have a combo box from the control tool box. Right now I am populating it
with a range of cells and I am trying to create a command button from Forms
Menu to run a macro that is determined by the link cell from the combo box.
The question I have is how do I create a nested Macro to call the appropriate
macro depending on what is selected in the combo box. Or can I use the combo
box to call on macros. If so how? I have been looking through other posts and
what ever I try does not seem to populate the combo box.

Need your help

 

[Bob Phillips]

If you select Design mode (the blue-green triangle on the control toolbox
toolbar), and then double-click the combobox, that will create a skeleton
combobox click event. Put your code in there. You get the combobox value
with

Me.Combobox1.Value

You don't need the button.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I got the button to work using if and elseif statements. I'm not sure how to
use the
Me.Combobox1.Value statement. I do not know the code that needs to be add
with it. Can I get that from you. A simple code that will display 3 items in
the drop down list and run a macro when selected and I will figure out the
rest.

Thank you