Input box hide typing

B

bill_s1416

I've got an input box on my worksheet using the VBA InputBox comman
that prompts for a password. The problem is the password is visible a
the user types it in. How can I make it so that only asterisks appea
as the user types? :confused
 
J

Jason Morin

I don't believe you can do this with an InputBox. But you
can with a textbox on a userform. Set the PasswordChar
property of the textbox to a symbol such as *.

HTH
Jason
Atlanta, GA
 
Top