LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Control ToolBox OptionButtons?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the control toolbox? Sol New Users to Excel 0 November 30th 06 02:20 PM
Where is the control toolbox? John New Users to Excel 0 November 30th 06 12:36 PM
Control Toolbox [email protected] Excel Discussion (Misc queries) 3 July 20th 06 03:10 PM
Control toolbox HISNA Excel Worksheet Functions 0 March 9th 06 05:14 PM
Control Toolbox John Data Excel Worksheet Functions 3 June 23rd 05 05:42 PM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"