Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validating entries in Excel forms?
I should've said, I'm using Excell 2002 SP2, in case that matters.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validating outside of Excel | Excel Discussion (Misc queries) | |||
How to validate entries with Data Forms in xls 2003? | Setting up and Configuration of Excel | |||
validating | Excel Worksheet Functions | |||
Validating non-blank cells in Excel 'form' | Excel Discussion (Misc queries) | |||
Validating | Excel Discussion (Misc queries) |