Select from multiple macros
 

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:confused:. 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

Select from multiple macros
 

use a case statement

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

--
Regards,
Tom Ogilvy

"aswert1223" wrote
in message ...

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:confused:. 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

Select from multiple macros
 

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

Select from multiple macros
 

Mark,

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


--
aswert1223
------------------------------------------------------------------------
aswert1223's Profile: http://www.excelforum.com/member.php...o&userid=15771
View this thread: http://www.excelforum.com/showthread...hreadid=486971