How to use InputBox for passphrase entry?

J

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?
 
D

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?
 
B

Bob Phillips

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

HTH

Bob
 
O

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

Joe User

Bob Phillips said:
You need to build a userform and use a textbox with
the PasswordChar property set to *

Thanks to all who responded similarly.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top