how change characres to stars when somebody is writting password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created macro and only few people will use it. How change characters to
stars(on monitor) when somebody is writing password?

below Is macro code:

Private Sub CommandButton2_Click()

Dim z As String

z = InputBox("enter password", "password")

If z = "example" Then
UserForm1.Show
Else
Exit Sub

End If
End Sub
 
You can't change the password character in an Inputbox. But you could use a
textbox on a userform with that textbox's .passwordchar property.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide password? 1
Modify sub to exit if password is incorrect 2
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
Combine three InputBoxes into one? 7
Password to Unhide VeryHidden Sheets 7
To color string of variable size 2
Connect to intranet 4
Change code to look at a range of columns not a single column 2

Back
Top