Drop Down List

  • Thread starter Thread starter travelersway
  • Start date Start date
T

travelersway

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?
 
you can select the cell and press delete,or right click and choose
clear contents, this will reset it
 
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 o
the last entry used. In the list below, if I select orange, the lis
doesn't default to the beginning (Red). You have to scroll back to Re
for the next entry. I'd like to open the list and find the first entr
(Red) and Scroll down.

EXAMPLE:

_List_
red
blue
yellow
green
black
white
orang
 
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?
 
Back
Top