| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Valiation and Excel Data Forms
I created a spreadsheet and added a maco to launch the form. Then added data
validation for one of the columns. When I use the form to enter data the data is not validated. I can type in the cell directly and the data is validated properly. How can I fix this? Appreciate your help. Marianne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Valiation and Excel Data Forms
Data validation only works with manual entry.
Since you are receiving the data in your form, then write the code to validate the entry. -- Regards, Tom Ogilvy "Marianne" wrote in message ... I created a spreadsheet and added a maco to launch the form. Then added data validation for one of the columns. When I use the form to enter data the data is not validated. I can type in the cell directly and the data is validated properly. How can I fix this? Appreciate your help. Marianne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data collection - aggrating forms data ?? | Excel Discussion (Misc queries) | |||
| data valiation, dropdown list question | Excel Discussion (Misc queries) | |||
| Excel 2007 data forms | Excel Discussion (Misc queries) | |||
| Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
| Data Forms in Excel 2002 | Setting up and Configuration of Excel | |||
Hybrid Mode
