Using password character "*" in InputBox

Question

I want to use * character in inputbox but an error prompts

conversion from "*" to string invalid 

How can I make my inputbox hide typed text into password characters?

Here is my code

Dim value As String
value = InputBox("Security Check", " Enter password", "*")

If value = "123456" Then
    numr.Enabled = True
End If
End Sub 

Answer 1

This is not possible with the built in Function InputBox. Ths value you are setting "*" is the defaultvalue of that function. http://msdn.microsoft.com/en-us/library/6z0ak68w(v=vs.90).aspx

Here is something you could do. http://www.vbforums.com/showthread.php?627996-Accepting-password-characters-for-InputBox-function