How to use InputBox for passphrase entry?

[Joe User]

Ostensibly, I would like to use InputBox (or the equivalent) to enter a
passphrase for an encryption algorithm. The problem: the passphrase is
normally in the clear when typing in the InputBox field.

Is there some way to cause the system to echo "*" or the equivalent for each
character as they are typed?

 

[dk]

Ostensibly, I would like to use InputBox (or the equivalent) to enter a
passphrase for an encryption algorithm.  The problem:  the passphraseis
normally in the clear when typing in the InputBox field.

Is there some way to cause the system to echo "*" or the equivalent for each
character as they are typed?

Why don't you put a text box into a Userform and use it as Input box?

 

[Bob Phillips]

You need to build a userform and use a textbox with the PasswordChar
property set to *

HTH

Bob

 

[OssieMac]

Hi Joe,

A textBox has a property whereby you can set the character you want to be
displayed in lieu of the real characters. Create a simple userform with a
TextBox or even place a textbox on the worksheet.

 

[Joe User]

You need to build a userform and use a textbox with
the PasswordChar property set to *

Thanks to all who responded similarly.


----- original message -----