Connect to Website / gSheet / MSExcel Online Before Executing Codes

[austinandreikurt]

Hi,

Is there a vba code in general that can connect to a website(html) or gsheet or msexcel online to see if log-in access that the user will input is "active" or "inactive".
Basically a Userform will prompt first then the user will input a username and password then check that credentials and match it to the active credentials maintained in a website.
Below is an ideal step by step of codes if any:

Sub Check_On_Site()

UserForm1.Show
'the userform will capture the TextBox1.Value as username1
'the userform will capture the TextBox2.Value as password1
Get url.....(lets say we are using an msexcel online path)
    then the usernames is in Column A of excel online, passwords in Column B, Textjoin username and password in Column C and Status whether Active or Inactive in Column D of MSExcel online
If username1 & password1 is lookup in Column D is Active
Then proceed with the code
Else MsgBox "please check admin for access issue"
End If

End Sub

Thank you in advance!