Password field

[tkaplan]

I have a macro where I want an input box to come up requesting a password.

is there any way that i can make it that the text field where they input the password will mask what they put in with stars or dots?

[Dave Peterson]

You'll have to create a userform with a textbox on it.

The textbox has a passwordChar property that you can set.

(Simple inputboxes don't have this.)

tkaplan wrote:
>
> I have a macro where I want an input box to come up requesting a
> password.
>
> is there any way that i can make it that the text field where they
> input the password will mask what they put in with stars or dots?
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=376256

--

Dave Peterson