Feb 07 2018
04:49 PM
- last edited on
Jul 25 2018
09:50 AM
by
TechCommunityAP
Feb 07 2018
04:49 PM
- last edited on
Jul 25 2018
09:50 AM
by
TechCommunityAP
When I try to add a User Form in a VBA project, I get an error that says "Component not correctly registered". This started happening a couple of months ago; I believe it was after I did a micrsoft update.
I've tried reinstalling Office which did not help. I'm not sure what else to try. And suggestions? If you need more information that would help diagnose the problem, please let me know.
Feb 07 2018 08:13 PM
VBA depends on VB 6.0 runtime!
Try to reinstall this runtime, this may fix the issue!
Feb 11 2018 11:34 AM
I reinstalled the VBA 6.0 runtime but I'm still getting the same error. I'm able to add a Module or Class Module just fine, so I find it strange that I'm only getting the error when trying to add a UserForm.
Feb 20 2018 07:30 PM
Feb 20 2018 08:10 PM
Feb 21 2018 06:19 AM - edited Feb 21 2018 06:20 AM
Jarad,
Please record the steps step by step from opening Excel till insert a UserForm using the Steps Recorder.
Make sure to start recording before you open Excel, and to stop it when you get the error message!
After you finish the recording, please save the recording steps as a zip file and attach it here in this community!
This will provide us with a detailed info about the issue.
Feb 21 2018 04:49 PM
I recorded the steps to reproduce the error; zip file is attached.
Feb 21 2018 07:58 PM - edited Feb 21 2018 08:32 PM
Please make sure that the file FM20.DLL is already found in this path:
C:\Windows\System32\FM20.DLL
I think it exists because you reinstalled the VB 6.0 Runtime.
Then make sure that the Microsoft Forms 2.0 Object Library is pointed to this file as below screenshot!
If it's not, please click browse and point the library to it.