Copy text box value to sheet after vlookup and next available row

[Zimmerman]

I have a userform that has a combo box (cboEmployee). This combo box is a drop down list of employees the user will pick from. Then there's a text box (Textbox1) the user will enter data in. There are 5 tabs representing each day of the week (Monday...Tuesday...Wednesday an so on). Each day of the week has the employees in column A. What I'm trying to accomplish is to lookup the employee (which was picked by the user in the combobox on the uerform) on Mondays tab and paste the value from the text box 1 in the next available row in Column C. The cells that are yellow is where I will be putting data in from the userform. So this is just the start of this project, but I figure if I get this one figured out I should be able to manipulate the code for the rest of things.

Thanks in advance
Excel 2016

 

[Zimmerman]

Your the best. Thank again! This is huge.....

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.