MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Create a dropdown calander in a cell?


Posted by M Perry on May 31, 2000 9:57 AM

Does anyone know if it is possible to create a dropdown box in a cell that would allow the user to pick a date from a calender (like the way you would pick the day from a dropdown box when creating an appointment in Outlook)? Thanks!


Posted by Ivan Moala on June 01, 0100 1:41 AM

Hi
You could try the mscal control instead
Have a look @
Here is some additional information you might find useful including a source
to download the calendar control.


http://www.microsoft.com/officedev/index/calendar.htm
Calendar control
[Includes links to 3 articles on the calendar control including
"Using a Calendar Control in Excel"]

HTH

Ivan