revised problem:

A combobox apparently does not update itself when changes are made to
its named range. Adding several entries or moving the range results in
the combobox having the wrong values until you close and reopen the
workbook.

My question is, how can I force a refresh of a combobox every time its
source range is changed? VBA is acceptable.


--
aoeui
------------------------------------------------------------------------
aoeui's Profile: http://www.excelforum.com/member.php...o&userid=26603
View this thread: http://www.excelforum.com/showthread...hreadid=398764