View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default How to use InputBox for passphrase entry?

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


Thanks to all who responded similarly.


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

"Bob Phillips" wrote in message
...
You need to build a userform and use a textbox with the PasswordChar
property set to *

HTH

Bob

"Joe User" <joeu2004 wrote in message
...
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?