Solved: input mask on inputbox

[philfer]

Hello,

I am using an inputbox to get a password from a user before the rest of the code executes. However, how can I get the test to appears as **** when the user types in the password.

In Access I know there is an Input Mask. Is there a similar thing on Excel and can I use it with InputBox

Cheers

[Marcster]

Yes, have a look here:

http://www.xcelfiles.com/API_09.html

Marcster.

[Bob Phillips]

Build a userform and use a textbox, that has a PasswordChar property which you set to *.