dakotasteve Wrote:
--I am trying to understand what I am doing wrong. I selected the
entire
column C in worksheet 1 for my validation entry test. The Data
validation
references the list of valid account numbers shown below, which is a
range
contained in worksheet2:
10400
12200
21010
26716
29000
29037
The validation is set to reference account numbers from the above list
(the
range is set up as the entire column B where this list occurs, though
the
list is only 40 or so account numbers, the entire column is referenced
in
case I want to add additional account numbers to the approved list at a
later
date). The Data Validation tab is activated to stop and show the error
alert
after an invalid entry. (I want to limit the user to selecting only
those
accounts on the validation list).

My problem is when I test it, it seems to accept any account number I
enter
in Cell C1 in worksheet1, without regard to the actual accounts I have
set up
on my data validation list in Column B in worksheet2. There is no
error
message that comes up when I enter the invalid account number, just a
drop
down box that allows me to enter any number I wish. What am I doing
wrong???Any help greatly appreciated!

DakotaSteve
Hi Dakotasteve,

The problem is is that you have put the whole column B as data
validation so you have 65,000+ blank cells in your validation.

Limit it to your 40 account numbers only

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568072