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?
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 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
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks