control to change sheet

  • Thread starter Thread starter EssieP
  • Start date Start date
E

EssieP

I want to be able to change a sheet by choosing an option from a drop-down
list, just like a jump-menu in web design. I have a collection of macros
that work as expected, but how do I attach the combo-box to the macro?

any ideas??

MrD
 
Assuming combobox from the control toolbox toolbar

in the click event, call your macro.
 
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

automatic sheet selection 2
How to link macro to change an item in drop-down list 1
Protecting sheets with drop down boxes 6
Drop down list and macros? 1
Macro to go to select sheet 2
Pasting cell contents into a macro 1
Excel Changing amounts from one sheet to another using specific item # 7
running macro in entire workbook 7

Back
Top