Mask Entries

[dparteka]

The code below works fine, I'm looking to mask the password entry. I've researched the internet and found some postings that claim masking is not possible with an InputBox, does anyone know if this claim is true?

    Dim Pass As String
    Dim Prompt As String
    Dim Title As String
    Dim UserPass As String
     
    Pass = "TurnTheKey"
    Prompt = "Enter password to continue"
    Title = "Password Input"
    UserPass = InputBox(Prompt, Title)
    If UserPass <> Pass Then
        Prompt = "Incorrect password, try again"
        Title = "Incorrect Password"
        MsgBox Prompt, vbCritical, Title
        Exit Sub
    End If

 

[Chihiro]

Correct. It can't be done using Inputbox.

You will have to create userform with textbox and set PasswordChar to "*" or something you want to use.


See link for documentation.
https://msdn.microsoft.com/en-us/library/Aa164894