dynamic range and data validation

G

GSB

Hi, I have list range where I put data validation to prevent users from
entering wrong options. Then I put a drop-down list that is populated from a
dynamic range of a list of valid options in another worksheet (same workbook)
and set up the data validation to show an error message if an user tries to
enter a non-valid option.

The thing is... it is not working. The drop down list works fine, but I
still can enter any value and recieve no message.

What am I not considering here???
 
P

Piscator

Highlight the cells.
Select Data, Validation.
The "Error Alert" tab is where you can insist an entry is only allowed
from the list as an Error, Warning or for Information only.
 
D

Debra Dalgleish

If there's a blank cell in the range you'll be able to type any value in
the cell with data validation.
If that's the problem, remove the blank cells from the range, or on the
Settings tab in the Data Validation dialog box, remove the check mark
from Ignore blank.
 
G

GSB

Well, I thought that checking the Ignore Blank option meant: YES IGNORE
BLANKS, which is what i want to do... but as you suggested, I un-checked it
and it is working just fine... thanks!!!
 

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

Top