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
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