ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Input Masking a Text box (https://www.excelbanter.com/excel-programming/320688-input-masking-text-box.html)

Neily[_3_]

Input Masking a Text box
 
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

Tom Ogilvy

Input Masking a Text box
 
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





All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com