LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to prevent each item date from changing after "TODAY" formula Marvin Excel Worksheet Functions 2 June 3rd 09 08:27 PM
Data Validation "List" - Setting length of list shown Dave Excel Discussion (Misc queries) 3 January 31st 08 06:51 PM
Can I include a "validation drop down" in a conditional statement? JanW Excel Worksheet Functions 1 June 5th 07 08:50 PM
"NOW" or "TODAY" date function Chris Excel Worksheet Functions 2 April 19th 06 07:46 PM
using VBA to emulate "validation" drop-down list Donager Dave Excel Programming 1 June 3rd 04 07:31 PM


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"