Date Drop-down list

[Guest]

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.

 

[Gord Dibben]

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

 

[TechGuy]

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