How to create a password login through a userform

Hi, i'm trying to create a password login userform after clicking on the command button into a sheet.

Firstly where i will be at the main page and i am suppose to click on the "staff access"
Step 1.jpg

Then a userform will be prompt and ask for password
Step 2.jpg

After getting the correct password, it will then move on the the specific sheet
Step 3.jpg

"StaffPage" (Sheet name for step 3)
"txtPassword" (textbox for step 2)

Sorry for the brief description

Something like this? I don't see any buttons on your "log in" form though.

Please Login or Register  to view this content.

Hi Millz, thanks for your help.

However, there is an compile error (Method or data member not found) on this line

Please Login or Register  to view this content.

btw the staff access will be the button for the "log in"

is it possible that i can include the userform on step 2?

"UserForm5"

It is supposed to be in your userform's code, in this case UserForm5's code.

You need to create a button though.

If you want to prompt for password directly upon clicking of "Staff Access", you should try moonsaga's solution.

What I provided was more for: Click "Staff Access" -> Open UserForm5, enter PW and click button.

yes, what i wanted was "staff access" -> open UserForm5, enter PW and click button -> "staffpage"

Sorry for the late reply btw.


Do you mean the command button like this
123.jpg

Hi Millz, i just understood what you meant earlier on and i have added a command button. But nothing happens after i click enter.

What's not working? The code in post #3 should go into UserForm5's code. Make sure the name of the Sub is correctly changed to the name of your "Enter" button too.

Hi millz, i have put the coding into the designated command button. but however i don't get any respond after click enter.

I apologize for the late reply.

Can't really tell what's wrong. Maybe attach a sample workbook.

Hi Millz,

This is the screenshot of my main page
MainPage.jpg

And this is the screenshot of the UserForm5 which is the login page
UserForm5.jpg

and in the command button "Enter", the codes are input from what you gave me.

Please Login or Register  to view this content.

However there is no error but i get no respond after click the enter even the textbox is blank or not.

once again, sorry for such a brief description.


And is it possible that i can prompt a "incorrect password" textbox when the password is input incorrectly then return it back to UserForm5?

Hi xia0jj

I see no problems, I've also tested the code myself, it works fine. Since you are facing a weird problem which I can't replicate on my side, I asked you to attach a sample workbook. But you gave more screen shots instead.

You get no response because you:
-left PW blank
-typed a wrong PW

Hi Millz, i don't think i can upload my workbook onto this forum. How bout i send you through your personal email?

And i get no respond regardless i leave it blank or type anything into the textbox

Lastly, i would like to apologize for my dumbness.

Hi xia0jj,

To upload a workbook, click "Go Advanced". Click on the paper clip icon and choose your file to be uploaded.
Please make sure you remove/replace any sensitive/confidential information before uploading.


Regarding the code, just in case you haven't noticed, there are really no code for a wrong/no password entered. Only code for jumping worksheet and closing the form if a correct password is provided. The correct password is "YourPassword" if you haven't changed it.

Please Login or Register  to view this content.

Hi xia0jj, since it's working, I wouldn't need to look at your workbook anymore.

If you want a message shown on wrong password just add in MsgBox.

Please Login or Register  to view this content.

No problem, all's well. Mistakes happen.

Good luck with your project