Here's one way to use the standard InputBox with a password character,
without having to create a userform...

http://www.danielklann.com/excel/hid...a_inputbox.htm

--
Regards,

Juan Pablo González

"Juan" wrote in message
...
Hi all!

Can anyone provide an example of how the passwordchar
property is used. I have a macro that sends an input box
that asks for a password... so far as you type the
password you can see what you ar typing. I would like to
see "*" or something like that....

Regards.. JS

...
PASS = InputBox("INPUT ACCES CODE: ", "RESTRICTED
ACCESS")
If PASS = "CORRECT" Then ....