View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default Data Validation drop-down

I have a cell with data validation drop-down in it. If I've already chosen
an item the list opens next time with tht item at the top of the list -
can't see the ones at the top unless I scroll up.

I want it to open showing the beginning of the list each time. Can I control
how it opens?

I am OK with a VBA solution if that's the only way to do it, too. but how
would I control that drop-down with code?

Thanks

M