D
dave caizley
Hi
I am fairly new to Macros but have created a worksheet in XL2003 that
contains 5 Command buttons created from the toolbox. Each of those buttons
operate a macro ranging from "Sub macro1( )" to "Sub macro5 ( )" basically
revealing or hiding selected rows.
An earlier enquiry has put me onto a Combo box where it will assign a
numerical value to a selection ie "One"=1, "Two"=2 etc.
In order to save space on my form, how can I assign Sub Macro1 ( ) to "One"
from the combo box and sub Macro2 ( ) to "Two" etc
Hoping someone can assist
Many thanks
I am fairly new to Macros but have created a worksheet in XL2003 that
contains 5 Command buttons created from the toolbox. Each of those buttons
operate a macro ranging from "Sub macro1( )" to "Sub macro5 ( )" basically
revealing or hiding selected rows.
An earlier enquiry has put me onto a Combo box where it will assign a
numerical value to a selection ie "One"=1, "Two"=2 etc.
In order to save space on my form, how can I assign Sub Macro1 ( ) to "One"
from the combo box and sub Macro2 ( ) to "Two" etc
Hoping someone can assist
Many thanks