Using a macro for a user-entry password - hiding the entry

[Eddie Kirby]

Is there a good way to hide the password entry when it is entered by a
user?

I have written a program which requires a password to make changes.
However, when a password is entered (example: XxBNB77T), the pass
word appears instead of **********.

Is there anyway to hide the password when it is being entered.

 

[Per Jessen]

Set up a userform, where user can enter the password in a TextBox. Use
* as PasswordChar in the Textbox properties.

Hopes this helps.
....
Per

 

[Dave Peterson]

You can use a textbox on a userform to get the info. The textbox has a
..PasswordChar property that can be used to hide the real password.