Password input textbox

[AJ]

Hi everyone,

Thanks in advance to anyone who can help here...

I have a userform in a workbook where I want the user to enter a username and password before the macro then goes and does it's funky stuff.
When they enter the password I want to show an asterisk for each character, rather than what they're entering (i.e. as you would expect.

How do I set such a textbox up?

Many thanks

AJ

[Sbirro Cornuto]

Set the PasswordChar of that TextBox to "*".

That can be done manually from the properties Window of the TextBox or by code like:

UserForm1.TextBox1.PasswordChar = "*"

change the UserForm1 and TextBox1 to whatever you have named those things.

[AJ]

Excellent.

Thanks!