Hi all,

I'm having some trouble with my drop-down list in excel. I've created a
macro to update a list of valid entries (from somewhere else in my
worksheet). And every time I update the list of valid entries, the drop-down
list starts with the position at the bottom. So I'll have to scroll upwards
to find my valid entries.

How can I adjust my macro to make the starting position of scrollbar at the
top of the drop-down list?

(I've tried to record the action of opening the drop-down list and pulling
the scroll to the top, but it won't record.)

Thankful for any tips...


Traima