Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date Drop-down list
Hi,
May i know how i can add drop-down of calender in a excel cell so i can quickly just click to pick up the date instead of typing on my keyboard? Thank you. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date Drop-down list
See how Ron de Bruin does it.
http://www.rondebruin.nl/calendar.htm Note the "more information" link to download mscal.ocx if needed. Gord Dibben MS Excel MVP On Tue, 3 Jul 2007 19:46:03 -0700, azlan wrote: Hi, May i know how i can add drop-down of calender in a excel cell so i can quickly just click to pick up the date instead of typing on my keyboard? Thank you. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date Drop-down list
On Jul 3, 10:46 pm, azlan wrote:
Hi, May i know how i can add drop-down of calender in aexcelcell so i can quickly just click to pick up the date instead of typing on my keyboard? Thank you. You can do something similar with WinCalendar... pick a date by simply right-clicking any exiting date in Excel ... see here for more info: http://www.wincalendar.com/excel-calendar.html Regards Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Can I put a calendar in a drop down list to select a date? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How to make drop-down list of dates start with current date? | Excel Discussion (Misc queries) |