View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carrie
 
Posts: n/a
Default Can a combo box activate different macros

Hello all

I currently have a worksheet that has about 10-12 buttons on it. Each
button activates a different macro that brings the user to a different sheet
within the workbook. The sheet looks very cluttered with so many buttons on
it and I wanted to create a combo box that will allow the user to select a
worksheet name, and when the worksheet name is selected, it brings the user
to that sheet.

It doesn't matter to me if it activates the current macros that were created
for the buttons or uses some other approach. I just want to clean the
worksheet up a bit.

One caviat - I'm not a programmer. I can read a little programming, but
haven't written anything. Any and all help is very much appreciated!
Thank you!

Carrie :)