Fix Excel VBA Component Not Correctly Registered When Inserting a UserForm
Question details
The user needs to resolve a component registration error when inserting an Excel VBA UserForm.
- Product
- Microsoft Excel Visual Basic Editor
- Device & OS
- not provided
- Scenario
- The user is inserting a UserForm in the Excel Visual Basic Editor.
- Observed behavior
- Excel displays a component not correctly registered error, although UserForms work in Word or Outlook.
Note the exact error message and whether it appears in a new workbook as well as an existing one. The Safe Mode and Office repair instructions below apply to Excel on Windows.
Test Excel in Safe Mode and isolate conflicting add-ins
Use this test to determine whether an add-in or startup customization is interfering with UserForms.
Close Excel, press Windows+R, enter excel /safe, and select OK. Alternatively, hold Ctrl while opening the Excel shortcut and confirm Safe Mode.
Open a new workbook, press Alt+F11, and choose Insert > UserForm in the Visual Basic Editor. If the form opens, investigate add-ins and startup items.
Restart Excel normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage list, click Go, and clear the enabled add-ins. Repeat with Excel Add-ins.
Restart Excel and test Insert > UserForm again. If it works, re-enable add-ins one at a time through File > Options > Add-ins, restarting and testing after each change.
Check the Forms library and repair Microsoft Office
Use these checks if the error persists in Safe Mode or after add-ins are disabled.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. It does not repair Excel's component registration error; test any VBA macros and UserForms separately before migrating.

Frequently Asked Questions
Which component should I register for an Excel VBA UserForm?
UserForms use Microsoft Forms components, commonly shown as Microsoft Forms 2.0 Object Library under Tools > References in the Visual Basic Editor. The error does not identify a particular DLL, so have IT diagnose the component and follow Microsoft's guidance before registering anything.
Why do UserForms work in Word but not Excel?
A working UserForm in another Office app does not rule out an Excel-specific add-in or configuration issue. Start Excel with Windows+R > excel /safe and test Insert > UserForm to help isolate the cause.
What if disabling add-ins does not fix the error?
Check Tools > References in the Visual Basic Editor for missing references, then ask IT to investigate the relevant Office or ActiveX component. You can also run Quick Repair or Online Repair from the Office entry in Windows Settings > Apps.
What should I do if Office repair and reinstallation already failed?
Give IT the exact error, the Safe Mode result, any missing references, and the repair and reinstall history. They can investigate component registration and permissions without repeating the same repair steps.




