Excel VBA - input box text display

M

mel41099

I have a macro that has an input box that asks for your password - an
when I type it in, I would like ***** to show up on the display, rathe
than what I am actually typing.

Is there a way to do this?

Thanks!!
-Meliss
 
T

Tom Ogilvy

Use a textbox on a userform and size it to look like an inputbox. Set the
passwordchar property of the Textbox to *
 
Top