Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping free text entry in validation cell
Hi,
I have an xls that I have set up with validation lists in some cells. I need to stop users from ignoring the options in the list and just typing whatever the want in the cell. Anyone help? I am sure it is easy, but can't see how to do it. Thnx, Smf |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping free text entry in validation cell
If you are using a list then that should be enough unless they copy and
paste into the validation cell -- Regards, Peo Sjoblom "smf" wrote in message ... Hi, I have an xls that I have set up with validation lists in some cells. I need to stop users from ignoring the options in the list and just typing whatever the want in the cell. Anyone help? I am sure it is easy, but can't see how to do it. Thnx, Smf |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping free text entry in validation cell
Hmm, sorry not using a list as such, it is something I picked up from here.
It is: =IF(E32="",RegionList,INDEX(RegionColumn,MATCH(E32 ,CustColumn,0))) in the validation source field. Not really sure what that is called - it picks up the data from another sheet that I have set up. As it is not a 'list' as such you are allowed to enter free text in the cell. Thnx, "Peo Sjoblom" wrote: If you are using a list then that should be enough unless they copy and paste into the validation cell -- Regards, Peo Sjoblom "smf" wrote in message ... Hi, I have an xls that I have set up with validation lists in some cells. I need to stop users from ignoring the options in the list and just typing whatever the want in the cell. Anyone help? I am sure it is easy, but can't see how to do it. Thnx, Smf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation to force entry in a cell | Excel Worksheet Functions | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions |