| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to select multiple text boxes in excel for formatting | New Users to Excel | |||
| MM/YY Formatting date Entry AND Display | Excel Discussion (Misc queries) | |||
| Allow Word type formatting in Excel text boxes | Excel Discussion (Misc queries) | |||
| formatting text boxes | Excel Programming | |||
| controlling date entry in a text box | Excel Programming | |||
Linear Mode
