Thanks for all of your feedback. Can any of you please give me a simple
example of this user form code. Also, how do I reference the userform when I
want to prompt for the password? Thanks.

"JE McGimpsey" wrote:

For that you'd need to use a UserForm. A Textbox control that you put on
the form has a property, PasswordChar that you can set to mask your
input.


In article ,
"Chad" wrote:

I am currently using an input box for password protection to allow a user to
perform a function, that I want to be limited, via a button, assuming the
input password is correct. Example, you press a button and an input box
prompts you for a password to access the data you are requesting. The
question is can I change the input text the user types in the input box for
the "password" to display "*" characters for every input character, like you
would normally see in a password input field? Thanks.