View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
eggpap eggpap is offline
external usenet poster
 
Posts: 29
Default 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