Microsoft VBA - Component not correctly registered

I cannot open any excel files that have Userforms as I get this message "Microsoft VBA - Errors occurred during loading".

If I open a blank excel file and try to insert a Userform I get a "Microsoft VBA - Component not correctly registered" error.

I have tried uninstalling and reinstalling office to no avail.

Can someone help me urgently?

Thanks

Barry

 

Question Info

Last updated November 16, 2019 Views 242 Applies to:
The problem is most likely with the FM20.dll which is located in C:\WINDOWS\system32 folder.  Try registering it and see if that overcomes the problem
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

The problem is most likely with the FM20.dll which is located in C:\WINDOWS\system32 folder.  Try registering it and see if that overcomes the problem

Thanks Doug. Could you give me some pointers on how to do that please?

I tried regsvr32 /u FM20.DLL and then regsvr32 /i FM20.DLL in command prompt but i get the following error

I should also note that userforms are working in Word, just not in excel

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.