How to USerform - only Userform Visible not Excel Sheet

How to USerform - only Userform Visible not Excel Sheet


Please click here for download File vba.
https://drive.google.com/open?id=1twWXZ1JAGuF0nLQYqaToj--fsqba4nKW


Step1-





step 2:-
Step 3





below vba code 

Private Sub SubmitB_Click()
If UsernameT.Value = "NITIN" And PasswordT.Value = "PASS" Then
Unload Me
Application.Visible = True

Else

MsgBox ("You are incurrect Passwor and user id")

End If


End Sub


---------------------------------------------------------------------------------------------



Private Sub UserForm_Activate()
Application.Visible = False

End Sub


--------------------------------------------------------------------------------
Private Sub Workbook_Open()
UserForm1.Show
End Sub

---------------------------------------------------

About Me

author Click here for Connect FB

Click here for Linkedin

Related Post No.

Powered by Blogger.

Contact Form

Name

Email *

Message *

Search This Blog

Recent Posts

Breaking

Popular Posts

Recent Posts

Trending Topic

Breaking

Related Post No.

Pages