Runtime 440 error when opening a UserForm

I made a column navigator userform a few weeks ago, and it's been working great. I have it saved in my Personal, and open it when I have a big workbook to navigate. Today it won't open, just gives me RunTime 440 Automation Error. I've attached the form and the code in the attached workbook. it's now working in the attachment, but not working from my Personal. I'd appreciate any help I could get in finding why it won't work today.

If you open the userform on an empty sheet

There is no used range

So your Userform Crashes At this point:

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

But I'm not opening on an empty sheet. I get the error on the line

Please Login or Register  to view this content.

no matter what workbook I'm working in.

No you are not.

Set a breakpoint at the top of your Userform Activate and also the Userform initialise subroutines.

Your Marco will get to one or both of these subroutines.

Step through using the f5 button until the userform crashes.





I see somewhere else where the Userform can crash

Please Login or Register  to view this content.

This only works if a is an array. Not So if you only Have one Entry.



Try this instead:-

Please Login or Register  to view this content.

I appreciate the wisdom, but no joy here. I set the breakpoints like you said. We didn't get that far. The crash happens right where I said. before Activate or Initialize is called. If I try to step through Activate, I get the error immediately. Same with Initialize.

Also, the sheets I'm trying it on have plenty of header fields, so there's no non-populated array.

Ok

So have you used

Please Login or Register  to view this content.

elsewhere in your macros?


Last thought.

Is the Userform in your Personal Workbook?

No on Dim a, Yes on Personal Workbook. The was in my initial post, and also the form has been in constant use for the past two weeks. Only today has it given an issue.

I guess you must have a corrupt personal workbook.

Export the Userform delete the macro. Close excel, Remembering to save the Personal workbook.

Open Excel

Reload the Userform

And Pray.

And that did the trick! Thanks for sticking with me through this!

Peter
As I have indicated in another thread this is an old solved thread. Please look to help current situations