Hide password in the InputBox

S

SKTing

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
 
P

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 **
SKTing said:
Pls help to insert any statement to the following Sub to hide the input
Click to expand...
password in the InputBox. Thank a lot
 
R

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

SKTing said:
Pls help to insert any statement to the following Sub to hide the input
Click to expand...
password in the InputBox. Thank a lot
 
Top