using inputbox to enter a password VBA

Asked Jul 27 '20 at 16:10

Active Jul 27 '20 at 16:13

Viewed 33 times

I have the bellow code to enter a password in order to open Excel worksheets, I want to hide the password i'm typing by showing only stars: ****. What should I add to my code? Thnk you

Private Sub bdd_Click()
    mdp = InputBox("Entrer le mot de pase de consultation : ", "Accés ficher FA")
    If mdp = ThisWorkbook.Worksheets("config").Range("E2").Value Then
    Unload Me
    ThisWorkbook.Application.Visible = True
    End If
End Sub

edited Jul 27 '20 at 16:13

BigBen

46,229
7
24
40

asked Jul 27 '20 at 16:10

FaruSZ

You need a `UserForm` with a `TextBox` control that has its `PasswordChar` property set to `*` – Mathieu Guindon Jul 27 '20 at 16:13
I know that I can do it with a userform, can I do it with an inputbox ? @MathieuGuindon – FaruSZ Jul 27 '20 at 16:17
No, you cannot do it with an `InputBox` function. – Mathieu Guindon Jul 27 '20 at 16:20
Okay thank you, I will switch to a userform then. – FaruSZ Jul 27 '20 at 16:30
1

Obligatory *Don't do that*. VBA is not secure for handling passwords. Any process, or user with local access will be able to intercept the password under the stars. – HackSlash Jul 27 '20 at 16:45
@HackSlash true that – Mathieu Guindon Jul 27 '20 at 17:20

using inputbox to enter a password VBA

0 Answers0