Thank you damorrison, but I don't want to remove data from the list.
I want to have the list open to the first entry in the list instead of
the last entry used. In the list below, if I select orange, the list
doesn't default to the beginning (Red). You have to scroll back to Red
for the next entry. I'd like to open the list and find the first entry
(Red) and Scroll down.
EXAMPLE:
_List_
red
blue
yellow
green
black
white
orange
--
travelersway
------------------------------------------------------------------------
travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
View this thread:
http://www.excelforum.com/showthread...hreadid=476762