Excel vba userform crashes excel when opened

Question

I have a userform on my spreadsheet which crashes excel and shows an Excel "System error &h8000ffff (-2147418113)" error message if I open the uf after copying and pasting data to several sheets. However if I open the uf immediately after opening the file it doesn't crash Excel. There is no code in the init function or any add-ins. I think the problem could be due to the data copy/analyze/paste functions which repeatably update a few tables, they run ok if i activate the sheet to be updated, but also crash Excel if i don't. The spreadsheet has a RTD feed and uses a class module to manage the tables. Could this be "unresolved ranges/links" or something similar?

Sub OPEN_CONTROL_PANEL_USERFORM()
    ufCONTROL_PANEL.Show
End Sub

Private Sub UserForm_Initialize()
'code commented out
End Sub

ChipsLetten · Accepted Answer · 2015-06-23 10:59:28Z

2

You could try running the free VBA Code Cleaner in case there's an issue with the VBA. It exports all the modules, deletes them from the project and then re-imports them which fixes some subtle issues like this. It's also a great way of exporting code modules for use with source code control.

I've used it a lot and recommend it.

answered Jun 23, 2015 at 10:59

ChipsLetten

2,9531 gold badge15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Zeus Over a year ago

Thanks this sounds very likely. I'll give it a try.

Zeus Over a year ago

That seems to have sorted out the small illogical bugs. Thanks for the suggestion.

T.M. Over a year ago

Caveat: As mentioned at the cited link, the VBA Code Cleaner DOES NOT support 64-bit versions of Excel

Collectives™ on Stack Overflow

Excel vba userform crashes excel when opened

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related