Try this

VB Code:
  1. 'set the input of an input box to password characters
  2.  
  3.  
  4. '---bas module code--
  5.  
  6. Option Explicit
  7.  
  8. Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
  9.  
  10. Public Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" (ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
  11.  
  12. Public Declare Function SetTimer& Lib "user32" (ByVal hwnd&, ByVal nIDEvent&, ByVal uElapse&, ByVal lpTimerFunc&)
  13.  
  14. Public Declare Function KillTimer& Lib "user32" (ByVal hwnd&, ByVal nIDEvent&)
  15. Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
  16. Public Const NV_INPUTBOX As Long = &H5000&
  17. Public Const EM_SETPASSWORDCHAR = &HCC
  18. Public Sub TimerProc(ByVal hwnd&, ByVal uMsg&, ByVal idEvent&, ByVal dwTime&)
  19.     Dim myHwnd As Long
  20. 'Change here App.Title (defoult InputBox Caption) into your caption
  21.     myHwnd = FindWindowEx(FindWindow("#32770", App.Title), 0, "Edit", "")
  22.      Call SendMessage(myHwnd, EM_SETPASSWORDCHAR, 42, 0)
  23.     KillTimer hwnd, idEvent
  24. End Sub
  25.  
  26. '--Using - form code:
  27. Private Sub Command1_Click()
  28. Dim sPass As String
  29. SetTimer hwnd, NV_INPUTBOX, 10, AddressOf TimerProc
  30. sPass = InputBox("Set Password")
  31. End Sub