Input box text format/hiding

Hello,

I would like to use an input box to obtain a user password before the rest of a macro is run. Is there a way to mask the user input as it is entered, as is commonly done for passwords (e.g., if the user types in bamboo6 in the input box, Excel recognizes bamboo6 as the password response, but it shows up on the screen as ******* as the user enters it)?

Thanks for any help.

Regards.

No, not on a standard Excel or VBA input box. However, you can create a user form that looks just like an input box to prompt for the password. On the user form, you would use a text box, and within the properties of the text box is the property 'PasswordChar' that you can use to mask the entered text. Just insert any character in this property field.

HTH

Jason

It pays to know smart people...