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.

putting a groupbox around your optionbuttons from the forms toolbar should
work. I suspect your controls overlap or are not totally contained in the
groupbox.

Get one row working.

Go down several rows (to insure no overlap) and get a second row working.

to convince yourself it can be done.

If you switch to the control toolbox toolbar, you will have to link to
separate cells for each button. You use the groupname property to group
them. Use any name you wish for the groupname but each group should have
unique names.

--
Regards,
Tom Ogilvy


" wrote:

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.

You may want to look at:
http://contextures.com/xlForm01.html
from Debra Dalgleish's site.

wrote:

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.

--

Dave Peterson

Tom,

You are correct. Apparently my group boxes were overlapping. It works
now.


Dave,

Someone else at work had just found the page you posted the link to. I
was just looking at your macro when I checked back here and saw your
reply. I'll see if I can adapt it to my project.

Thanks to both of you.

Dave,

I was able to user your macro for my project.

Do you know of a way to sort the columns with the option buttons after
the user makes the selections? We will have a spreadsheet that a user
fills in from a list. The columns to the left of the columns with the
option buttons will be filled in by the user. The first column contains
the last name of a student. The data will be sorted by last name after
everything is entered. The columns with the option buttons are not
being sorted with the rest of the columns. Can I sort the columns with
the option buttons along with the other columns?

Thanks for any help.

Make sure you include all the columns that need to be sorted in the range to be
sorted.

If you're selecting one column and then using the icon on the Standard toolbar,
try selecting the whole range and use Data|Sort.

wrote:

Dave,

I was able to user your macro for my project.

Do you know of a way to sort the columns with the option buttons after
the user makes the selections? We will have a spreadsheet that a user
fills in from a list. The columns to the left of the columns with the
option buttons will be filled in by the user. The first column contains
the last name of a student. The data will be sorted by last name after
everything is entered. The columns with the option buttons are not
being sorted with the rest of the columns. Can I sort the columns with
the option buttons along with the other columns?

Thanks for any help.

--

Dave Peterson

It's kind of strange. Columns A to H have data the user enters. Columns
I to T have the option buttons. Column U is the cell link. If I select
columns A to U and use Data|Sort, it will sort all the columns
including U except columns I to T (with option buttons). If I select
columns A to T, it will sort I to T. Of course column U is excluded on
the latter. I tried setting the cell link to a column left of the
option buttons. If I then select all columns, it will sort the columns
with the option buttons but not the column containing the cell link
value. I'm stumped.

Dave Peterson wrote:
Make sure you include all the columns that need to be sorted in the range to be
sorted.

If you're selecting one column and then using the icon on the Standard toolbar,
try selecting the whole range and use Data|Sort.

wrote:

Dave,

I was able to user your macro for my project.

Do you know of a way to sort the columns with the option buttons after
the user makes the selections? We will have a spreadsheet that a user
fills in from a list. The columns to the left of the columns with the
option buttons will be filled in by the user. The first column contains
the last name of a student. The data will be sorted by last name after
everything is entered. The columns with the option buttons are not
being sorted with the rest of the columns. Can I sort the columns with
the option buttons along with the other columns?

Thanks for any help.

--

Dave Peterson

Tom,

You are correct. Apparently my group boxes were overlapping. It works
now.


Dave,

Someone else at work had just found the page you posted the link to. I
was just looking at your macro when I checked back here and saw your
reply. I'll see if I can adapt it to my project.

Thanks to both of you.