Hello,

I created a spreadsheet with several combo boxes that that is linked to
other data.

When this data is sorted, the values in the combo boxes are
automatically changed.

Is there any way to prevent the the values to change?

Thank you.


--
i4c4p4
------------------------------------------------------------------------
i4c4p4's Profile: http://www.excelforum.com/member.php...o&userid=36490
View this thread: http://www.excelforum.com/showthread...hreadid=562483

How about copying the data to a separate range and sorting the range.
Your combo box will still be pointing at the original data.

e.g

Column A1:A10 Data
Combo box points to A1:A10

Macro to copy data to column B
Sort column B


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562483

This will not work, the data in the data range is changed on an hourly
basis and my boss will not want to maintain 2 lists.

Any other ideas.


--
i4c4p4
------------------------------------------------------------------------
i4c4p4's Profile: http://www.excelforum.com/member.php...o&userid=36490
View this thread: http://www.excelforum.com/showthread...hreadid=562483