View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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 ....