424 object required in userform

[SPARKY347]

not to sure why I get this when trying to load my userform, I have checked the spelling and not quite to sure of any other casuses

Please Login or Register  to view this content.

[cytop]

There's no other cause, a referenced object does not exist.

Either you don't have a userform called 'FindInvoice' or else code in the userform refers to another object that doesn't exist. There's not enough information in your very brief post to say for sure

[Kamboj]

You can check it by just open your project explorer(Alt+F11) and press F8 for step by step to see what is missing in your form.

[SPARKY347]

so by setting the break points ive traced It back to the line where is try to add my dynamic named range to combobox2

Please Login or Register  to view this content.

below is the code in the named range to add the jobs to the range, it seems to work in the names section?

=OFFSET(jobs!$A$2,0,0,COUNTA(jobs!$A:$A),1)

[mikerickson]

Giving a named range the same name as one of your worksheets might cause issues, but.

Have you tried syntax like

Please Login or Register  to view this content.

That will also cause problems if there is only one value in the column. The .Value of a one cell range is not an array so the .List will balk.