Sorting a column that has Combo Boxes

jase

Board Regular
Joined
Nov 4, 2002
Messages
62
Okay,

Last question of the day. I have a column that strictly contains combo boxes. The combo boxes are referenced to cells so that the options, let's say for simplicity sake, are: "a", "b", "c", "d" & "e".

Try as I may, I cannot get this column to sort properly. I even tried linking each individual combo box to the cell address where it resides (the ole right mouse click "format control" option) but that doesn't seem to work. I get very strange results -- but no ascending or descending order.

Has anybody any experience trying to sort a column with combo boxes?

Any help is, as always, greatly appreciated.

Thanks. jase.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Jase - I don't think you can do this because of the fact that the cells are linked - you could easily replicate the linked cell values in an alternative column and then sort but I would imagine this is not your aim...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,230
Messages
5,594,949
Members
413,953
Latest member
Arthur1471

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top