listbox validation for column of cells doesn't work

  • Thread starter Thread starter NF
  • Start date Start date
N

NF

In Windows 2000 professional, using Excel 2000 SP-3, I
entered validation values "high", "medium", and "low" into
A1:A3. I then selected column B, and selected Data-
Validation to specify "List" validation. I
Click to expand...
entered "=A1:A3" as the source.

The result is that a proper listbox appears for B1, but
the listbox for B2 contains only "medium" and "low", and
B3 contains only "low".

A bug?
 
Back
Top