Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell data validation
Hello,
in one Excel2003 task I have some cells linked to a code list to get the data validation. The codes in the list are numbers or mixed numbers and letters. The mixed codes can be indifferenctly selected from the dropdown list in the cell or directly typed in it, the code numbers, instead, can be only selected from the dropdown list. I get error if I type it in the cell directly (item not present in the list). When the user knows the code would be easier to type it directly in the cell. Emiliano |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Validation of data in a cell | Excel Discussion (Misc queries) | |||
Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
data validation - more than one in same cell? | Excel Discussion (Misc queries) | |||
Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) |