View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default How to use InputBox for passphrase entry?

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?