Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Masking Password in the inputbox

0

How to Mask your password in the inputbox

excelmacros-vba
MS Office Version: 365
posted by: ALEX63GO on Wed Mar 10, 2021 at 7:01 am
Answer
Discuss

Answers

1

Hi Alex and welcome to the Forum

Take a look at what Microsoft recommend here: How to create a "Masked Password" dialog box in Office programs by using Visual Basic for Applications

Revision 1: Once you've done that, put this code behind the CommandButton on your Userform (changing names in bold if necessary):

Private Sub CommandButton1_Click()
MsgBox TextBox1.Value
Unload UserForm1
End Sub
When you launch the Userform, type the password (it will appears as a string of asterisks like *****), click the button to enter the form. It will reveal what you typed in a MessageBox (but you'll take that value and check it etc.) and close the form.
posted by: John_Ru (rep: 6142) on Wed Mar 10, 2021 at 7:08 am
Discuss

Discussion

Alex

Did you get that to work?
John_Ru (rep: 6142) Mar 12, '21 at 10:35 am
Thanks Don. Nice video!

I got no reply from Alex so don't know if my Answer was useful, too hard to follow or Alex simply couldn't be bothered to reply!
John_Ru (rep: 6142) Sep 28, '21 at 9:24 am
Add to Discussion
0

I hope you got your issue solved! If not, you can check out this tutorial.

I just made it into a video tutorial that shows the process from start-to-finish.

Make a Password Prompt Input for Excel (With Masked Input)

posted by: don (rep: 1989) on Tue Sep 28, 2021 at 8:34 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login