Validating entries in Excel forms?
Check out Data Validation Allow Date Set the parameters Ok out
HTH
Regards,
Howard
"SteW" wrote in message
...
Hi, I've made a nice little form in excel, where people can enter some
data,
then have it added to a spreadsheet.
The problem is, I can't work out how to validate any of the data.
eg. One of the fields required is 'Date', and at the moment you're free to
write anything in there. You could type 'poo' if you wanted, you'd get no
errors or warning messages.
So how can I set up some data validation?
Cheers,
|