how can I change input statement to show only stars for password ****

[SAM SEBAIHI]

When you enter your password in this line, you can see what you are entering, how can you change the following line so it will only show ******** as a password when you are entering your password??


ans = InputBox("Enter your password", "password")

Thank you for all of you help


--------------------------------------------------------------------------------

 

[Dave Peterson]

The builtin inputboxes won't let you do this.

But you could create a small userform and use the .passwordchar property to hide
that input.

 

[Dave Peterson]

ps. This is a text only newsgroup. You may want to refrain from posting in
HTML.

 

[JMB]

One way you could approach it is to set up a userform with a textbox for
entering the password. Textboxes have a passwordchar property that allows
you to display an "*" instead of the actual text.

 

[SAM SEBAIHI]

I didn't know, I will refrain from posting HTML. Thank you.
How can you use .passwordchar property with this ans = InputBox("Enter your
password", "password") I am fairly new in VB.

Please let me know.
Thank you for you help.

 

[Dave Peterson]

Inputbox won't allow this.

You'll have to make a userform.

Check Debra Dalgleish's site:
http://contextures.com/xlUserForm01.html

Tom Ogilvy posted these links:
Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

I didn't know, I will refrain from posting HTML. Thank you.
How can you use .passwordchar property with this ans = InputBox("Enter your
password", "password") I am fairly new in VB.

Please let me know.
Thank you for you help.