View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jjordan jjordan is offline
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