Select from multiple macros

[aswert1223]

I have a requisition sheet almost complete for its users. There are about 25 macros to print, change view, etc.

My problem is that I cannot find an elegant way for the user to select from the macros. I want to use a combo box, but I cannot find a way to associate a different macro with each combo box item.

Any suggestions?

Thanks!

Jack

[Tom Ogilvy]

use a case statement

Select Case Combobox1.ListIndex
Case 0
mymacro3
Case 1
mymacro2
Case 2
mymacro5
End Select

--
Regards,
Tom Ogilvy

"aswert1223" <[email protected]> wrote
in message news:[email protected]...
>
> I have a requisition sheet almost complete for its users. There are
> about 25 macros to print, change view, etc.
>
> My problem is that I cannot find an elegant way for the user to select
> from the macros. I want to use a combo box, but I cannot
> find a way to associate a different macro with each combo box item.
>
> Any suggestions?
>
> Thanks!
>
> Jack
>
>
> --
> aswert1223
> ------------------------------------------------------------------------
> aswert1223's Profile:
http://www.excelforum.com/member.php...o&userid=15771
> View this thread: http://www.excelforum.com/showthread...hreadid=486971
>

[Mark]

Where are you placing this ComboBox. Is it embedded in one of the
worksheets or is it attatched to a menu?

[aswert1223]

Mark,

I plan on 2 combo boxes (views & print controls) directly on the worksheet. They will not appear on the printed pages.