Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent each item date from changing after "TODAY" formula | Excel Worksheet Functions | |||
Data Validation "List" - Setting length of list shown | Excel Discussion (Misc queries) | |||
Can I include a "validation drop down" in a conditional statement? | Excel Worksheet Functions | |||
"NOW" or "TODAY" date function | Excel Worksheet Functions | |||
using VBA to emulate "validation" drop-down list | Excel Programming |