PDA

View Full Version : Solved: Help Required - Checking formats of cells



AnkitGupta
02-07-2012, 09:58 AM
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

xld
02-07-2012, 10:15 AM
Use data validation, that has a number of different options to test input.

AnkitGupta
02-09-2012, 09:27 AM
thanks... :)