Vba - restricting cell vallue

[ajliaks]

Hi all,

I need to restric the vallue of a cell, to this format:
"dd-mm-yy"

and prevent user inputing like this:
"dd.mm.yy" or "dd/mm/yy"

I tried using Excel - Data - Validation, but unsuccessfully.
Is there anyway to do this with Vba?
may be something like:

Workbooks(activeworkboo.name).Worksheets(activesheet.name).Cells(x,y).Forma
= "dd-mm-yy"

But it has to PREVENT user's inputing.
Thanks in advance.
Aldo

 

[Tom Ogilvy]

Any valid date entered into a cell can then be formatted to look like
dd-mm-yy