Hi,
I have 3 sheets in a Workbook named in the brackets.
1. The main LOGIN sheet(Login)
2. Second sheet containing list of 101 usernames and passwords in column A and Column B respectively (Admin)
3. The sheet which you navigate to after logging in successfully. (Metric)
I need a VBA code to perform the below actions:
1. Input for username and Password
2. Validate if the Username and password is right by checking the sheet 'Admin' of the worksheet
3. If the Login details are valid, then navigate(open) to the sheet 'Metric'.
4. If the Login details are not valid, then pop up a MsgBox prompting "Invalid Credentials"
I have 3 sheets in a Workbook named in the brackets.
1. The main LOGIN sheet(Login)
2. Second sheet containing list of 101 usernames and passwords in column A and Column B respectively (Admin)
3. The sheet which you navigate to after logging in successfully. (Metric)
I need a VBA code to perform the below actions:
1. Input for username and Password
2. Validate if the Username and password is right by checking the sheet 'Admin' of the worksheet
3. If the Login details are valid, then navigate(open) to the sheet 'Metric'.
4. If the Login details are not valid, then pop up a MsgBox prompting "Invalid Credentials"