Assign macro to each item of a drop-down list or combo box - how?

  • Thread starter Thread starter jbp20717
  • Start date Start date
J

jbp20717

I've posted this a while ago, but I keep getting the same recurring
problem, namely that I can't get it to work...and I'm not 100% sure
that people really knew what I was on about before anyway :)

I desperatly need to have a macro that will launch a specific macro
when an item is selected in the combo box or drop-down list. i.e. I
have a list with item "X" and item "Y" and macros "X" and "Y" which
need to run when the corresponding items are clicked on. I need to
create macro "Z" which I can assign to the combo box/drop-down list
which will allow me to do this.

Please bear in mind I have near to zero knowledge of VBA.

Thank you in advance ;)
 
To avoid repetition, what replies did you get before, and what was wrong
with them?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate list or combo box from closed workbook 4
Help with creating drop down 1
Print Macro with two drop-down lists 4
Define the Range of a drop-down list 5
ActiveX Control Combo Box 9
Start a macro when cell >=0 1
Sorting of table depending on a drop-down-list entry 4
EXCEL DROP DOWN 2

Back
Top