View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jswalsh33 jswalsh33 is offline
external usenet poster
 
Posts: 51
Default Drop Down List Format


I have worksheets with a number of drop down lists created with data
validation. I would like the operator to be able to edit these lists, so I
have put in a number of blank cells at the bottom of each list. When the list
is selected the scroll goes to the bottom of the list (blank cells). I have
checked the ignore blank cells box on the validation, but that does not fix
the problem.

Is the a way to get the drop down list scroll to start at the top?

Thanks for your help.

Jim