How do I solve "runtime error '-2147352573 (80020003)' " in Excel/

[Guest]

I am making this macro that pops up a user form that takes user input and
performs some action on some of the worksheets. This macro has got quit a bit
of code written behind it.
Now I hav started getting this error message saying "runtime error
'-2147352573 (80020003)' "when I try to run this macro..and the user form
doesnt pop-up..

 

[Guest]

You have to debug the macro. Got to the tools menu and select macro - visual
basic editor. Under Debug you can step through the code (F8) and put break
points (F9) to find the problem. I would run the macro from the visual basic
menu (F5) and see where the error occurs. It should stop and highlight the
line of code that is bad. You can move the mouse over the different variable
to see there values or add the variables tto the watch window.