Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display masking goto_guy Excel Discussion (Misc queries) 2 March 30th 06 11:38 PM
Masking numbers RNeducator Excel Worksheet Functions 2 December 2nd 05 02:25 PM
masking hklemmons Excel Programming 2 September 18th 04 04:08 AM
Masking character Joe Excel Programming 1 September 13th 04 04:17 AM
Bit Masking Merlyn Knight Excel Programming 2 March 5th 04 08:19 AM


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"