Adding an input mask to data validation

Hi all.

Is it possible to use VBA to add an input mask to cell validation in excel.

I want users to add dates without needing to put in a slash or dot in between the different date segments.

Cheers

Zigi

you could set the DV rule to allow certain types of integers - depending upon the format you wish to allow

for ex. assume you want people to enter YYYYMMDD format, a Custom DV rule [A1]like below would enforce valid "date" entry:

=ISNUMBER(TEXT(A1,"0000\-00\-00")+0)

and you can use the exact same construct with dependent cells to convert the A1 value to it's Date Serial equivalent