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(activeshe et.name).Cells(x,y).Forma
= "dd-mm-yy"

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

--
Message posted from http://www.ExcelForum.com