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?
 
Hi

You need to make your references absolute - by using the $ sign:

$A$1:$A$3

Andy.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro not working properly when run automatically 9
Compare 2 columns with words to 1 and to get the 3rd word. 13
Drop down list & Time Zones. 2
Find a value in table 2
Multiplying to string arrays 2
Numerating Cells. 2
Selected dropdown value pushes to other cells 1
sumif??? 4

Back
Top