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
---------------------------------------------------
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
---------------------------------------------------