VBA & Macro Problems

Fix Excel VBA Component Not Correctly Registered When Inserting a UserForm

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK. Alternatively, hold Ctrl while opening the Excel shortcut and confirm Safe Mode.

2
Test a UserForm

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.

3
Disable add-ins

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.

4
Identify the conflict

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.

If Safe Mode does not help: The error may involve an Office component rather than an add-in. Continue with the component checks and repair steps.
Free Microsoft Office alternative

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.

Open and edit common Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday workbook tasksMove compatible Office documents into a lightweight productivity suiteUse WPS Office for free
microsoft office alternative - wps office

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.