Userform Not writing to second worksheet

Hello Everyone

I am having a problem trying to get a combo box (CboLoc)and a text box(txtJobNum) to save data to a second work sheet
the CboLoc uses a list range to pull data form sheet called JobDB and populate the CboLoc and txtJobNum this works Ok
But if I enter a new name in CboLoc and number in txtJobNum it will not find the first blank row or write it to the JobDb sheet

Every thing works till this point in my code With ThisWorkbook.Sheets("JobDB")

Below is my code so far

Please Login or Register  to view this content.

Thanks for any help on this

Hello mmikem,

We would be much better off trying to help you if we knew where the Code is placed. In the Userform or a Sheet.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.