VBA: Error Message: "Class Not Registered" Inserting UserForm

When you attempt to insert a UserForm while you are in the Microsoft Visual Basic Editor in one the products listed at the beginning of this article, or when you attempt to open a document that contains a UserForm, you may receive the following error message: When you click Help, the following message appears: The dialog box is dismissed when you click OK.

The error may also appear when you attempt to save a Microsoft Excel 97 document as an Hypertext Markup Language (HTML) document by clicking Save As HTML on the File menu. When you click OK, a dialog box with the following message appears:

This problem may be caused by a missing or incorrect Microsoft Windows registry entry for the Dynamic Link Library Fm20.dll. The proper registration of this file is required when you work with UserForms and form controls in Microsoft Excel 97.

To resolve this problem, register Fm20.dll. You must have Regsvr32.exe to register Fm20.dll. If you do not have Regsvr32.exe you can download the file. For additional information, please see the following article in the Microsoft Knowledge Base:

Registering Fm20.dll

To Register Fm20.dll, follow these steps:

1. Use Microsoft Windows Explorer to locate the Fm20.dll file in the Windows\System folder or in the Winnt\system32 folder (under Microsoft Windows NT).
   
   If the file is not present, copy it from the OS\System folder on the Microsoft Office 97 compact disc to the appropriate location.
2. Close all open programs.
3. Click Start on the Windows taskbar, click Run, and then type the following:
   Regsvr32.exe fm20.dll
4. Click OK. The following message should appear:
   DllRegisterServer in c:\windows\system\fm20.dll succeeded.

The file Fm20.dll should be registered correctly.

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.