Userform listbox adding rowsource runtime error 380

I have a multipage userform;
- Page 1 has listbox1 and textbox1
- page 2 has listbox2

Basically my code searches for the value in textbox1 and outputs the result into listbox1.
Then my code uses the selected value in listbox1 to perform another search and the results should appear in listbox2
It also adds a worksheet with the name of the selected listbox1.value

Please Login or Register  to view this content.

Everything works fine except for this bit:

Please Login or Register  to view this content.

I keep getting a runtime 380 error & I have no idea what the issue is.

Any assistance appreciated!

Not always, but it is a possibility.

Thanks Norie & D.
Problem solved.