VBA Validate textbox value to have alphanumeric characters

[hydz1213]

Hi all!

Please assist me in solving this problem.
I just want the textbox to check upon exit event if the value entered is alphanumeric.
I have a code that checks every keypress if user enters non-alphanumeric characters. But again, I also want it to make sure that user entered alphanumeric characters coz this textbox is for user password.

Thanks!

Here's my code:

Please Login or Register  to view this content.

[BigBas]

Would something like this help you out?

Please Login or Register  to view this content.

[hydz1213]

Hi BigBas!
Thanks for replying
I tried your code but the textbox accepts all type of entries upon exit, may it be letters only, numbers only, or aplhanumeric.

Any more insight?
Thanks!

Any more insight?
Thanks!

[BigBas]

Perhaps I misunderstood your request. You are correct, the code allows letters, numbers, or both. Are you asking to REQUIRE that the user enter at least one letter and one number?

[hydz1213]

Perhaps I misunderstood your request. You are correct, the code allows letters, numbers, or both. Are you asking to REQUIRE that the user enter at least one letter and one number?

Yes, BigBas! I'm sorry if I confused you. This textbox is where user needs to enter their new password. And I believe, for better security, it's better for a password to be alphanumeric, right?

Thanks again in advance!

[BigBas]

That sounds right. Earlier, I though you were trying to block the user from entering NON alpha-numeric data (special characters such as: ! @ # $ etc).

The below code requires at least 1 letter and 1 number. You can further strengthen the password by requiring a minimum length, or any other requirements.

Please Login or Register  to view this content.

[MarvinP]

Hi,

I always thought lower case, upper case along with numbers in a password made it stronger. See:
http://netforbeginners.about.com/od/...g-password.htm

[hydz1213]

Thank you so much, BigBas!!!
That worked perfectly! Also, I limit the password length to 10 characters only, as you recommended.

Hi MarvinP,
I'll also look into your link to find more insights. For now, I'm tagging this post as SOLVED!

Thanks for this forum as always!

[BigBas]

Glad to help!