Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a User form with (20) option buttons on it. It does what I want by
only being able to check 1 option button. Option Button Names: OB_601 OB_602 - OB_619 OB_620 What I need help with is when user checks the correct option button, that button exicutes code located in a module. Code in Module: There are (20) Subs named like below Sub String_01() Sub String_02() - Sub String_19() Sub String_20() I think the code for each Option button is something like this, because there default position is False and they only show true when selected. If OB_601 = True then call Sub String_01() If OB_602 = True then call Sub String_02() If OB_603 = True then call Sub String_03() Etc.... End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling Option Buttons - Control | Excel Programming | |||
Worksheets and Control Option Buttons | Excel Worksheet Functions | |||
No control for option buttons, invisible macro?? | Excel Programming | |||
Selective control of Option Buttons | Excel Programming | |||
Control Box Option Buttons | Excel Programming |