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


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

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.

SAM SEBAIHI wrote:


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

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

SAM SEBAIHI wrote:


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

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" wrote:


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


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

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" wrote in message
...
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.

SAM SEBAIHI wrote:


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

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...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

SAM SEBAIHI wrote:

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" wrote in message
...
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.

SAM SEBAIHI wrote:


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

--

Dave Peterson