Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format data with an input mask like ss# (***-**-****) | New Users to Excel | |||
Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
Time input mask format | Excel Discussion (Misc queries) | |||
date mask | Excel Discussion (Misc queries) | |||
Excel 97, text box Input Mask, local date format | Excel Programming |