Asterix when password entered into InputBox

[adste89]

Hi,

I am using the code as below to password protect the use of a macro. Do you know how I can change it to show "****" instead of "password" when the user is typing it in??

Please Login or Register  to view this content.

Merci,

Adam

[mike7952]

I dont know if you can do that with an Inputbox, but you can create a small userform with a textbox for the password entry. Then in the textbox property PasswordChar you can enter * or whatever you want to.

[adste89]

Yea I've seen this sort of suggestion around when trawlng the web...I'll try and replicate this then. Thanks a lot for your help.

[JosephP]

your only alternative is api calls and a userform is much simpler to do :-)