Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 .... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 .... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|