Passwordchar Example

[Juan]

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 ....

 

[Bob Phillips]

Inputbox doesn't support Passswordchar, you would need a userform for that.
If you do use it, you just specify * as the Passwordchar, and that is what
is echoed back for every character entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Juan Pablo Gonzalez]

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

http://www.danielklann.com/excel/hiding_text_in_a_vba_inputbox.htm