Hi

I'm a fairly new user to Macros

I have a worksheet created in XL2003 that contains five buttons created from
the toolbox. Each button successfully runs its own unique macro basically
hiding and showing specific rows. The Macros are caller Sub Macro1( ) to Sub
Macro5( )

Having just come accross Combo boxes where the source data is allocated a
numerical value ie "One"=1, "Two"=2 etc, I would like to allocate Sub Macro1(
) to "One" and Sub Macro2( ) to "Two" etc. so that I can save a lot of space
in my workbook

How can I do this please

Many thanks