[VBA] Userform to show upon opening excel sheet, then use a password to log in.

[LittleJon]

Please could someone give me the code for opening up a userform upon opening an excel sheet. Userform is called MainUF1. Then i need to put in a username and password.

Any help would be appreciated.

 

[LittleJon]

the userform would close.

 

[mumps]

I'm not sure what you mean by:

the userform would close.

Perhaps it would be best if you could explain in detail, step by step, what you want to happen when you open the workbook.

 

[LittleJon]

When i open the workbook a userform would pop up. When i enter a username and password into that userform, it would close and allow me to use the workbook.

 

[LittleJon]

If you just need the userform to open, then this will do it:

Private Sub Workbook_Open()
    MainUF1.Show
End Sub

This doesn't bring up the userform.

 

[mumps]

If the name of the userform is MainUF1, then it should show on opening the workbook. Did you place the macro in the code module for ThisWorkbook as I described in Post #4 ? What are the names of the text boxes on the userform that will contain the username and password?

 

[LittleJon]

the text boxes are called TBUsername & TBPassword, i double clicked on the userform and put the code in.

https://ibb.co/jqC9yA

 

[mumps]

Click here to download a sample file.