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