Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've got a form with a few text boxes which are used to collect dates and was wondering if anyone knew of an easy way to make the text boxes only take a date format, kinda like the Input Mask function you can use in Access. Any ideas anyone? Ta. Neily |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can use the afterupdate or exit events to examine the input and react to
it. The change event or one of the key events could be used to examine the entry in progress. The is no built in mask function/setting or validation function/setting. -- Regards, Tom Ogilvy "Neily" wrote in message ... Hi, I've got a form with a few text boxes which are used to collect dates and was wondering if anyone knew of an easy way to make the text boxes only take a date format, kinda like the Input Mask function you can use in Access. Any ideas anyone? Ta. Neily |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display masking | Excel Discussion (Misc queries) | |||
Masking numbers | Excel Worksheet Functions | |||
masking | Excel Programming | |||
Masking character | Excel Programming | |||
Bit Masking | Excel Programming |