Formatting Text boxes for Date Entry
 

Is it possible to create a text box on a form in Excel, to facilitate
date entry?

In other words, I'd like to have a text box on a form in which the user
only has to enter month, day, and year - with the slashes already
built-in as an input template.

Can this be done?

Thanks,
Dennis Hancy
Eaton Corporation
Cleveland, OH

Formatting Text boxes for Date Entry
 

Excel's textboxes don't support that kind of masking.

But maybe you could just let the user choose from a calendar control???

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

" wrote:

Is it possible to create a text box on a form in Excel, to facilitate
date entry?

In other words, I'd like to have a text box on a form in which the user
only has to enter month, day, and year - with the slashes already
built-in as an input template.

Can this be done?

Thanks,
Dennis Hancy
Eaton Corporation
Cleveland, OH

--

Dave Peterson