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.

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.

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