LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Mask date format

Hi there,

I am trying to find a way to "mask" a date field so the user cannot change
the format of the column, or enter any other format other than as I specify.
I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not
enter dd/mmm/yyyy it will either not accept when they are typing or prompt
"invalid date format" upon leaving the field.

Thanks,

JJ
 
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
how to format data with an input mask like ss# (***-**-****) Dennis New Users to Excel 2 March 28th 08 10:31 PM
Need A date Mask format for a Textbox on UserForm [email protected] Excel Discussion (Misc queries) 2 November 4th 07 02:27 AM
Time input mask format WNB-96740 Excel Discussion (Misc queries) 2 December 16th 05 03:15 PM
date mask sgibbs Excel Discussion (Misc queries) 1 August 17th 05 10:50 PM
Excel 97, text box Input Mask, local date format Kevin McCartney Excel Programming 3 November 9th 04 08:23 PM


All times are GMT +1. The time now is 06:28 AM.

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

About Us

"It's about Microsoft Excel"