Drop Down List
 

I use drop down lists with many bits of information. When I open the
lists after they have been used, the list does not go back to the first
enty in the list.

What do I need to do to make the list default to the first enty?


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=476762

Drop Down List
 

you can select the cell and press delete,or right click and choose
clear contents, this will reset it

Drop Down List
 

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

Drop Down List
 

OH,
if you would clear to cell and then the next time you pulled the cell
down the list would be at the top, that is what I was talking about,
Is your list in VBA?