Hiding password characters

[Guest]

Hi!

I've just added an InputBox function to my macro that requires users to enter a password, otherwise the other procedures do not run. However, there's a problem: when the user types the password, characters are revealed, they're not replaced by *. How can I make this change via macro?

Thanks

 

[Paul B]

You can not do it with a input box, you will have to use a user form and a
text box to do it and set the passwordchar to what you want to show like
*****

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Hi!

I've just added an InputBox function to my macro that requires users to

enter a password, otherwise the other procedures do not run. However,
there's a problem: when the user types the password, characters are
revealed, they're not replaced by *. How can I make this change via macro?