Hide password in the InputBox

[Guest]

Pls help to insert any statement to the following Sub to hide the input password in the InputBox. Thank a lo

Sub Fast_Update(
UserNameStr = InputBox("Key in SiView user ID"
PasswordStr = InputBox("Key in SiView password"
If UserNameStr = "" Then Exit Su
If PasswordStr = "" Then Exit Su
Call Update_Lot_Status(1, True, False
End Su

 

[Paul B]

You can not set the password character in an InputBox
You could create a userform with a TextBox and set the PasswordChar property
to * to hide the password

--
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 **

Pls help to insert any statement to the following Sub to hide the input

password in the InputBox. Thank a lot

 

[Robin Hammond]

SK,

Instead of using an inputbox, use a custom form with two text boxes and an
OK button. In the VBE you can set a password character for one of the text
boxes in the properties pane and it will mask the user entry.

Robin Hammond
www.enhanceddatasystems.com

Pls help to insert any statement to the following Sub to hide the input

password in the InputBox. Thank a lot

 

[Ivan F Moala]

If you must use an Inputbox then see here for 2 ways to accomplish this.

http://www.xcelfiles.com/API_09.html
or
http://www.danielklann.com/