Logic for creating Passwords.

[kiki13140702]

Hi all,

I am trying to create a user form for entering passwords. There are two text box, first one- enter a 7 characters long, and must include exactly 1 digit ( cannot be more than 1 or 0), and also no space is allowed. The second text box will ask me to enter the password again, and check if the two attempts are the same.

I believe for checking the 7 character, Len(test) can be used

Not sure what to use for checking if there is exactly 1 digit ? In the case of more than 1 digits and 0 digit need to be handled separately?

What about the space ( any function for check space in a string??)

Any help is appreciated !! Thank you!!

[martinez77]

This is a fairly involved process where you will have quite a bit of code. Fortunately there are lots of functions in excel vba to handle comparisons, but where will you store the passwords and other operational items will need to be considered. Below is a good link to get you started if you haven't already found it.

https://www.youtube.com/watch?v=E2xRf1hZKtY

1. Your would need to add some comparison code and run through the entire password string.
2. You will be using lots of if statements. to check conditions. Google excel vba comparison string, character of string etc.

I know this is not the answer you were looking for, but something is better than nothing

Best,