View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Husker87 Husker87 is offline
external usenet poster
 
Posts: 35
Default Drop down that returns to the last selection and can be formated.

I have a form that requires the user to enter a date. I have a years worth
of €śSundays€ť in a range. I used Date Validation but when you select a new
date the drop down returns to the top of the list. When I use a combo box
the drop down list returns to the last selection but wont format €śMMM-D€ť.

Any suggestions on what I can use to get a date drop down list that returns
to the last selection. As the year goes on the users have to scroll down
quite a bit. (I only put 1 years works of weekly dates in the range)

Thanks