View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hoshyar Hoshyar is offline
external usenet poster
 
Posts: 25
Default Validation, how to see "today" date on top of the drop down list?

I have a drop down list for the days of the year, form 1 jan 05 to 31 dec 05.
when I click on the drop down list, it always shows me 1 jan on the top of
the list, then I have to scrol down and look for "today" date. is there any
possibility that when I click an empty cell where the drop down list is
activated and see the "today" date? I mean when use it today I want to see
the date 16 Oct 05 on the top of the list, and if I use it tomorrow I want to
see 17 october 05 and so on.

Your help is appreciated.
Hoshyar