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" wrote in message
...
Pls help to insert any statement to the following Sub to hide the input
password in the InputBox. Thank a lot

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

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/