Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation - Force entry from drop down list
I'm trying to force the data entry from the drop down list. I thought if I
set the Error Alert to "Stop" it would prevent any entry other than that from the drop down list, but I can still enter data not on the drop down list. How can I the cell to only accept data from the drop down list? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation - Force entry from drop down list
Hi,
Look into Debra web http://www.contextures.com/xlDataVal02.html "JeffH" wrote: I'm trying to force the data entry from the drop down list. I thought if I set the Error Alert to "Stop" it would prevent any entry other than that from the drop down list, but I can still enter data not on the drop down list. How can I the cell to only accept data from the drop down list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
Use Validation to force specific entry of first 3 characters in st | Excel Worksheet Functions | |||
Validation to force entry in a cell | Excel Worksheet Functions |