Does value exist

[llan_man]

I have a userform where the user enters their username. I also have an admin sheet which stores all the usernames of the people who can access this model. What I am looking for is some code which will check whether the username that the user enters into the form is on the admin sheet list.

Not sure where to start....

I've tried using ISna combined with vlookup and not sure how to use Find.

Thanks

Harv

 

[Aladin Akyurek]

I have a userform where the user enters their username. I also have an admin sheet which stores all the usernames of the people who can access this model. What I am looking for is some code which will check whether the username that the user enters into the form is on the admin sheet list.

Not sure where to start....

I've tried using ISna combined with vlookup and not sure how to use Find.

Thanks

Harv

=ISNUMBER(MATCH(UserName,UserList,0))+0

1 means Yes, 0 No.