Dots, instead of characters in InputBox

Hi Folks,

I have an InputBox popping up first when the user attempts to open a UserForm and it asks for a password to unlock the protected worksheet. Works fine.
Now, I'd like to have dots appearing in the InputBox, instead of the password itself.
This is because we are operating many occasions via NetMeeting so I just do not want all the people in the world and their dogs to see what that password actually is.

Arigato gozaimasu

Gabor

Hello!
On the properties of your Input Box, put the dot character or whatever character you liked in the PasswordChar Property.

The inputBox does not have a password character property.

You might add a textbox (which has a passwordcharacer property) to the userform and hide all other controls on Initialize until the proper password is entered.

All right, so there is no easy way out, gotta create another userform, to let the user in.
Actually I like the idea to hide/unhide all the other controls with a loop, as a feasible alternative to the second UF.
Thanks guys, I'm gonna get there now.

Please Login or Register  to view this content.

Originally Posted by mikerickson

The inputBox does not have a password character property.

You might add a textbox (which has a passwordcharacer property) to the userform and hide all other controls on Initialize until the proper password is entered.

mikerickson,

my bad, thanks for correcting, you were correct, i was thinking of the textbox and not of the input box.