| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
I am creating a form in excel which would be filled by user. I want to creat
some cells that only accept specifc numeric values. for example in cell A1 I want user to be entered numbers from 5 to 10, if less or greater values entered an error window appear asking to enter values from 5 to 10. If it is possible, please help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200903/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Hi
Select the cell you want then Goto DataValidation and set your criteria. HTH John "adeel via OfficeKB.com" <u32736@uwe wrote in message news:93519bcf4a64c@uwe... I am creating a form in excel which would be filled by user. I want to creat some cells that only accept specifc numeric values. for example in cell A1 I want user to be entered numbers from 5 to 10, if less or greater values entered an error window appear asking to enter values from 5 to 10. If it is possible, please help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200903/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
