Combo box on a user form

Hello and thank you in advance

I am using Office 2016 and I need help. I've already got this set up as below in an Excel sheet where the user goes to cell H4, clicks the drop down, and selects a company and the cells in I4, J4, K4, and L4 fill as appropriate. Now I want to hide all of this, move it to a user form with a combo box and I haven't done this before. Here is the user form and here is the code. Lastly I've attached the sheet

I'm getting an error message that I dont know how to fix. What am I missing?

Thanks for any help

Thank you Torachan,

I do have a sheet called "Backups" and the combo box is on the user form which I plan to place on that sheet. How do I fix it?

Thank you Richard!

I planned to figure out the combo box first and then move on to each of the text boxes but you did it all and it works beautifully! Thank you!

My only question is that I have a line in Private Sub UserForm_Activate() which says .SelText = "Select". I thought this would insert "Select" at the top of the combo box drop down and I'm not seeing it. Any ideas?

Hello Richard, I am having a tough time moving the pieces you helped create back into the original spreadsheet. I made a scaled down version of the original. What's the best way to get your stuff back into the original? Im not a programmer

Thank you once again Richard. The user form is working but I have one last remaining issue that isn't working.
1. I have this code to show the user form when the user goes to the backups sheet (it's on Module 1 as you have it) but it doesn't appear when I go to the Backups sheet.
Sub LoadBackups()
Backups.Show
End Sub

What am I missing?