change letter in an Inputbox to *

[MarkCBB]

HI there Guys and Girls,

I am using some an inputbox in some code as a password to certain sheets in the workbook, I would like to have the letters of the password when entered by a user appear as dots for as *, is this possible with an inputbox or should I change to a userform?

 

[mikerickson]

The InputBox cannot mask password characters.
A userform is needed.

BTW, Chr(165) is a solid dot • .

 

[careywalker]

I have not tried this myself but this link might provide what you are looking for: http://www.xcelfiles.com/API_09.html

 

[MarkCBB]

Thank you for all the responces, I am going to opt for a userform. thank you.