What about without a userform? I have a statistical analysis spreadsheet,
where the user begins the execution by clicking a "Run" button in a
worksheet. I then prompt for a password, using an inputbox. If the entry is
validated, the code executes. Is there an alternative to the inputbox, or is
there a way to obscure the user entry into it?


"Bob Flanagan" wrote:

On a userform add a text box and put "*" in for the password character.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"AVR" wrote in message
...
Is there a simple way to create a password input box triggered by clicking
a
button in excel. I need the user entry to be obscured by some character,
like "*".