Thread: Copy and Paste using worksheet change

The form initiates, but when I click "add job" within the form, it gives me this error. I tried to debug but i kept getting "stuck" on this same section of code - it just kept going through this section over and over.. I am assuming this is the error, but that's being assumptive. What do you think is up?

For Each objControl In Me.Controls
    If objControl.Name = tb Then
    objControl.AddItem ""
    objControl.AddItem "Tiesen"
    objControl.AddItem "Jones"
    objControl.AddItem "TN"
    objControl.AddItem "Mie"
    objControl.AddItem "Jackson"
    objControl.AddItem "Mills"
    objControl.AddItem "Robertson"
    objControl.AddItem "Benley"
    objControl.AddItem "SAT"
    objControl.AddItem "Roscoe"
    objControl.AddItem "Lemon"
    objControl.AddItem "LC"
    objControl.AddItem "Chit"
    objControl.ListIndex = 0
    Exit For
    End If
Next

Also, I know that this is the code for the combo boxes and they are fine. So that's why I said it was assumptive. But, I could not get past this section of code to attempt and debug like you requested. I am really sorry all this junk is going on..

That loops over all the controls and finds the comboboxes and adds the values - this won't be the error. Place a Breakpoint next to EnterJob.Show (not the load command) and then hit F5 - the code will run and load the comboboxes then stop just before showing the form. Then start hitting F8 again and see where the error occurs. We need to narrow down where the error is actually occurring. I have added more error handling to the new version. You are using Excel 2010? 32bit or 64bit version? Use the attached workbook. Reboot your machine as well.