Custom Valdiation Help

[mattie]

I am having some issues with custom validation, in cel N6 i have some custom valdiation set up to see if that value appears in a list on a seperate worksheet and if it doesnt pop up a error box, the code i currently have is:

=INDIRECT("Users!A2:A17115")

But when i try and test it the error box keeps coming up. I think i need to add soemthing to it but am not sure what.

cany anyone help?

Thanks

 

[GTO]

Greetings,

Try using a Name. In the Refers To: =Users!$A$2:$A$17115

Name it MyRef (or whatever)

In the cells you want DV, in the Allow box, choose List. In the formula box, "=MyRef"

Hope that helps,

Mark

 

[GlennUK]

...

 

[mattie]

Thanks Mark, the issue i am havng now is that when i put incorrect enteries in the error box isnt coming up

 

[GTO]

Hmmm... I just tried it, so I suspect I didn't communicate some part.

On the Error Alert tab of the dialog for defining the DV, do you have Style selected as Stop?

 

[mattie]

Yeah, i have also removed the in cell drop down as i want the users to input their id and then the validation check that it is contained on the list and if it is continue and if not throw up the message

 

[GTO]

I cleared the In Cell Dropdown checkbox and it still get stopped cold.

My bet is that you have blank cells in your list.