Restrict the date format entered in a cell

Hi,

I am working on a excel sheet where the user has to enter a date.

Now when the user enters the date in a format than the pre-determined format(say, 03/10.2010), an error message has to pop up.

fpr ex- my predetermined format is mm/dd/yyyy. If the user enters dd-mmm-yyyy then it has to give an error message "wrong format....."

I know MACROS have to be used to get this functionality. But iam a novice in macros...

Any help is appreciated.

Thanks

hi ross....

1) the validation applies to a selected range of cells in a colomn.

2) version of excel- 2003.

3) Country is US......

will update my profile today

Now, how do i integrate this code to my excel sheet?

thanks for the tip shg....

now, when I come back to excel and try to run the macro from tools----macros---run---, the macro that's written with the code in this thread, just doesn't show up for some reason....

as a result i cannot run the macro......

FINALLY got it to run shg......phew...

but, is there any way where we can get around the "one at a time" functionality. I mean when i try to copy about 10 dates into the range say,"A10:A20" for which the macro is defined, the program returns" one cell at a time" and terminates.....

is there any workaround for this, so that the code also works for more than 1 cell at a time..in other words, if i paste 10 date value into the range defined by the macro, it shld still work...

thanks

bump......................