Calendar
 

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

Calendar
 

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

Simon Shaw wrote:

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

Calendar
 

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

"Dave Peterson" wrote:

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

Simon Shaw wrote:

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