Thread: validation list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default validation list

If I have a cell (say A1) with a validation list and I have values in other
cells of the same column (A), when typing a letter into A1 Excel (2003)
offers the first value in column A beginning with the letter just typed in
cell A1, as is the case in normal inputting.
In my opinion it should be more useful, if in the case of inputting into
cells with a validation list (A1) Excel would take the value offered for
input not from column A, but from the source of the validation list. E.g.
typing letter "B" int cell A1 should result in offering the first value of
the source beginning with "B", simultaneously displaying the validation drop
down list positioned on the value offered.

Regards,
Stefi