Passwordchar Example
 

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

Passwordchar Example
 

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

Passwordchar Example
 

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