What is wrong with this for loop?

[kmakjop]

Hello, I am having a challenge with the code below. I have a list of names on sheet3 column A4 to A10, the list of names are the only people that should be able to broadcast an email from the application. When the person enter their username in the textbox, if the name entered is not in the range sheet3 column A4 to A10, then a message should return saying that you are not authorized for email broadcasting. The userform should not close, but the username textbox (textbox1) should have focus.

When i try the code below, it triggers the message if the username i entered is not in the range, but the challenge is, it also triggers the message if I enter the correct name in the textbox. I think this means it’s not reading from the right sheet column A.

Kindly help, thank you in advance.

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[AlphaFrog]

Another suggestion:

Please Login or Register  to view this content.

[sktneer]

Try this.....

Please Login or Register  to view this content.

[kmakjop]

Thank you all for responding so quickly and accurately, they all worked. Sorry for thanking so late.

[sktneer]

Glad to help you. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.