Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel2003 ... I know nothing regarding Code (Zero, Nada, Zilche) ... Now that
I have that out of the way ... I have a WorkSheet from another that has Control Box Option Buttons (42 of them) in Range (B5:H11 ... with exception of Row 10) ... In Design Mode "Properties" each Button is linked to a Cell: Button1 ... B32 Button2 ... C32 Button3 ... D32 Button4 ... E32 Button5 ... F32 Button6 ... G32 Button7 ... H32 Buttons8 thru 14 linked to Row 34 (as above) Buttons15 thru 21 linked to Row 36 (as above) Buttons22 thru 28 linked to Row 38 (as above) Buttons29 thru 35 linked to Row 40 (as above) Buttons36 thru 42 linked to Row 42 (as above) Issues is ... when I select any Button (TRUE) all other Buttons in the Range B5:H11 go FALSE ... What I want is: Select Button in Row 5 (TRUE) ... Remaining Row 5 Buttons (FALSE) Select Button in Row 6 (TRUE) ... Remaining Row 6 Buttons (FALSE) Select Button in Row 7 (TRUE) ... Remaining Row 7 Buttons (FALSE) Etc ... Please ... I know the short-coming here is on my part ... so I am hoping one of you Wizards on this board can tell me how I reset the RANGE that these OptionButtons appear to be looking at ... Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the control toolbox? | New Users to Excel | |||
Where is the control toolbox? | New Users to Excel | |||
Control Toolbox | Excel Discussion (Misc queries) | |||
Control toolbox | Excel Worksheet Functions | |||
Control Toolbox | Excel Worksheet Functions |