LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Grouping Option Buttons

I would like to have 12 option buttons grouped together in each row.
The option buttons for each row should be independent of the ones in
the other row.

I added option buttons from the forms toolbar for the first row and
drew a group box around them. I did the same for the second row. After
selecting a box on the first row, I then select a box on the second
row. Selecting a box on the second row deselects the box on the first
row. Both rows are being treated as one group. I need them to be
independent. The user should be able to select one option for each row.

I've tried setting the cell link to the first cell for each row under
Format Control. But setting the cell link to the first cell in row 2
also changes the cell link to the same value in row 1. In other words,
I'm not able to have A1 as the cell link for row 1 and A2 as the cell
link for row 2 at the same time. It's always A1 for both rows or A2 for
both rows.

What am I doing wrong? Should I be using the forms toolbar or the
control toolbox? It seems that it should be very straightforward.

 
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
Grouping Option Buttons ion a Group Box [email protected] New Users to Excel 5 October 15th 06 07:29 PM
Auto Grouping of Option Buttons Rafat Excel Programming 4 July 7th 06 04:30 PM
Grouping radio option buttons ahmed Excel Programming 1 May 1st 06 11:13 PM
grouping of option buttons mapi62 Excel Discussion (Misc queries) 0 February 22nd 05 12:19 PM
Grouping Option Buttons m@_ Excel Programming 3 November 5th 03 02:20 AM


All times are GMT +1. The time now is 04:14 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"