Hello all, I am new to VB and have got Excel VBA for dummies to start and help me learn, but unable to find a solution.
I have a userform setup that has a Combobox1 and a Textbox1. I am trying to set the coding up so that Combobox1 has a list of usernames and Textbox1 the user is able to enter their password. I have the rangesource for the Combobox1 set to get its list of names from column A and the password list is in column B from sheet "UserPass", but it will be hidden.
My issue is getting the coding to validate the password based on the combobox value and then filling in the row on the worksheet "TimeSheet" that matches the username.
I have attached my file with userform so far.
Thanks for the help in advance.
Bookmarks