VBA InputBox Password Validation

Waaaa. I type the word simple .

Always back in GoTo PasswordNotAcceptable

I'd do it like this, goTos are horrible It's also useful to let the user know what they've done wrong:

Please Login or Register  to view this content.

Though I think your logic is probably flawed, the only time password complexity means anything at all is when you set a password to open, there's no point in doing it anywhere else. Also, why do you not want to include special characters?

@Kyle - Why I don't like special characters because I don't know how to do the logic about it. I want to make my workbook protected. A macro that the user can protect there work and when a user opens it there is a password. Thanks for the code. It works. I will study more about it.

So you're setting a password to open with excel setting the prompt rather than a macro? You don't really want to be prompting for a password in your code as it's inherently insecure - anyone can bypass it. If you want to include special characters then just change:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Originally Posted by Kyle123

So you're setting a password to open with excel setting the prompt rather than a macro? You don't really want to be prompting for a password in your code as it's inherently insecure - anyone can bypass it. If you want to include special characters then just change:

I don't get your point Can you explain it more simpler.

Thank you for your great help again.

Originally Posted by Winon

Personally I would use a UserForm for entering a Password, where no one can see what is being typed in as the Password, only ****. Entering a Password via an InputBox, displays exactly what is being entered, without obscuring the actual characters, and just maybe someone may see it, and your Password is compromised.

I really want to do that asterisk mark for password **** but I don't know using UserForm and a textbox and a button. Don't know how to call and end the process. And I only use BeforeDoubleClick the cell, that is all I know.

Can you make a sample of that UserForm.

I don't really know haw to rephrase it any more explicitly. Excel code is not secure and worksheet protection is not secure, it is trivial to remove the protection put in place on these objects. AS such password strength is completely pointless. The only time a stronger password matters is when you require a password to open a workbook, this is set when saving. If that's what your doing, then all well and good - but why not just use the password box built into Excel when saving the workbook?

Then there's no point in making your password complicated - it doesn't matter how complicated you make a password due to how Excel stores it. - You can still easily set a password to lock a sheet from the protection options. Making it complicated also makes it more likely that your users will forget it and you'll have to find a way of unlocking their worksheet - it's one of those rare circumstances where you'd actually go for a simple password

Ok. Thank you for your advice and for your help. It helps me a lot realize and learn something.

For now I will mark this thread as a solve. Thanks.