This was inspired by Dick Kusleika’s post Masking Passwords (http://www.dailydoseofexcel.com/archives/2011/07/12/masking-passwords/). It’s an enhanced version of DK’s approach in the sense that the same userform module supports both entering a new password as well as entering a password for confirmation. There are other enhancements. The user can choose to either mask or unmask the password. The developer has more choices about what is and is not allowed in the password.
For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1061%20Password%20Userform%20module.shtml
Here’s another enhancement: checking the password strength.
http://www.codeforexcelandoutlook.com/excel-vba/password-strength-checker/
That is very cool. I can use that. I use UserForms all the time; I love their ease of use. Let me try this out and i will come back and post again.