Hi,
I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848 Automation error. The object invoked has disconnected from its clients' appears and shuts down excel. This doesn't happen every time that the user form is used but I can't predict when it will happen. I've looked through the code and I can't see where there's an issue. What does this error mean and are there common code errors that cause it?
I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848 Automation error. The object invoked has disconnected from its clients' appears and shuts down excel. This doesn't happen every time that the user form is used but I can't predict when it will happen. I've looked through the code and I can't see where there's an issue. What does this error mean and are there common code errors that cause it?