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

Ahhh. When I sorted, I only looked at the results of the data.

You're right, the linked cells don't stay with the row with the groupbox/option
buttons.

I think you'll have to reassign those linked cells after sorting.

So I would think that you'd have to sort the data in code, too.

wrote:

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

--

Dave Peterson

If you rightclick on each of the buttons and choose Format Control, then the
Properties tab, you should see that the "move, but don't size with cells" is
checked.

And if your zoom isn't set to 100%, the buttons may not be in the cells that you
think they are.

I'd make sure that the zoom is set to 100% when I added them and the same when
the data is sorted.

====
Just to add to the previous message:

And the linked cell is assigned to an address--not the cell. So if the buttons
change position (say from row 24 to row 2), the linked cell/address is still in
row 24.



Dave Peterson wrote:

Ahhh. When I sorted, I only looked at the results of the data.

You're right, the linked cells don't stay with the row with the groupbox/option
buttons.

I think you'll have to reassign those linked cells after sorting.

So I would think that you'd have to sort the data in code, too.

wrote:

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

--

Dave Peterson

--

Dave Peterson

Dave,

Thanks for the clarification on the linked cell. For my purposes, it
probably won't matter if the address remains in the original row after
the sort. I would only need the value in that cell to sort with its
corresponding cells in the other columns. I'm still not able to get
those values and the cells with the option buttons to sort at the same
time. It is always one or the other.

The zoom is set to 100%, and "move, but don't size with cells" is
checked. I also verified that each button is in the "correct" cell.

I don't know what to do at this point. Thanks for your help.

Dave Peterson wrote:
If you rightclick on each of the buttons and choose Format Control, then the
Properties tab, you should see that the "move, but don't size with cells" is
checked.

And if your zoom isn't set to 100%, the buttons may not be in the cells that you
think they are.

I'd make sure that the zoom is set to 100% when I added them and the same when
the data is sorted.

====
Just to add to the previous message:

And the linked cell is assigned to an address--not the cell. So if the buttons
change position (say from row 24 to row 2), the linked cell/address is still in
row 24.



Dave Peterson wrote:

Ahhh. When I sorted, I only looked at the results of the data.

You're right, the linked cells don't stay with the row with the groupbox/option
buttons.

I think you'll have to reassign those linked cells after sorting.

So I would think that you'd have to sort the data in code, too.

wrote:

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

--

Dave Peterson

--

Dave Peterson

That column of linked cells sorted with the data in my tests.

But if I clicked on any of the buttons, the linked cell updated--and it may not
have been in the same row.

If you need the cell that gets updated to be on the same row as the buttons, I
think you'll have to reassign those linked cells.

wrote:

Dave,

Thanks for the clarification on the linked cell. For my purposes, it
probably won't matter if the address remains in the original row after
the sort. I would only need the value in that cell to sort with its
corresponding cells in the other columns. I'm still not able to get
those values and the cells with the option buttons to sort at the same
time. It is always one or the other.

The zoom is set to 100%, and "move, but don't size with cells" is
checked. I also verified that each button is in the "correct" cell.

I don't know what to do at this point. Thanks for your help.

Dave Peterson wrote:
If you rightclick on each of the buttons and choose Format Control, then the
Properties tab, you should see that the "move, but don't size with cells" is
checked.

And if your zoom isn't set to 100%, the buttons may not be in the cells that you
think they are.

I'd make sure that the zoom is set to 100% when I added them and the same when
the data is sorted.

====
Just to add to the previous message:

And the linked cell is assigned to an address--not the cell. So if the buttons
change position (say from row 24 to row 2), the linked cell/address is still in
row 24.



Dave Peterson wrote:

Ahhh. When I sorted, I only looked at the results of the data.

You're right, the linked cells don't stay with the row with the groupbox/option
buttons.

I think you'll have to reassign those linked cells after sorting.

So I would think that you'd have to sort the data in code, too.

wrote:

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

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson