Validating entries in Excel forms?
 

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,

Validating entries in Excel forms?
 

I should've said, I'm using Excell 2002 SP2, in case that matters.

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,