Solved: Help Required - Checking formats of cells

[AnkitGupta]

Hi,

I have a spreadsheet which is filled by different people, due to which some of them fill -

• Character values into cells which should contain only numeric values or
• Fill the wrong date format (instead of dd/mm/yyyy they fill mmm-yy or mm/dd/yyyy)

Is there any way by which I can prevent them from doing this? I guess we can use Worksheet_Change event - but how?

I am just a beginner with VBA, would really appreciate your help guys.

Kindest Regards.
Ankit

[Bob Phillips]

Use data validation, that has a number of different options to test input.

[AnkitGupta]

thanks...