| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation based on range of values
Thanks, Dug. That site is great - gave me what I needed.
It does lead me to another question. Is there any way to force the user to use the drop-down arrow to select the values rather than plow over the validation and type in the value they want? If I stick to the drop downs, everything works great. However, if I type in a value, the out of range value is accepted. TIA from an Excel neophyte. Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List - Dependant based on numeric values | Excel Discussion (Misc queries) | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
Threaded Mode
