Calendar

[Guest]

I am developing a Form in VBA. I need the user to enter a date. Is there
control available that can display a calendar for selecting a date?
Can I validate a Text Box to require a date, similare to Data Validation in
an on a worksheet cell?

thanks

 

[Dave Peterson]

You may want to use a freeware version of a calendar control.

From Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm

You can also Download the control on this page.
A Pop-up Calendar for Excel
http://www.fontstuff.com/vba/vbatut07.htm

 

[Benjamin]

Dave Nice Web-sites.... that's really useful stuff!