OFF2000: "System Error &H80004005 (-2147467259)" Running Macro with UserForm

ID: Q230888

The information in this article applies to:

SYMPTOMS

When you run or open a Microsoft Visual Basic for Applications macro with a UserForm, the following error message appears:

System Error &H80004005 (-2147467259). Unspecified error.
This may be followed by these error messages:
Out of memory
Run-time error 7. Could not find the specified object.


CAUSE

This problem occurs when the following conditions are both true:

These errors occur in Microsoft Excel, Microsoft PowerPoint, Microsoft Word, and Microsoft Access with a UserForm created in the Visual Basic Editor. The UserForm cannot be accessed to change it after these errors.

NOTE: If this control is added to an Access form separate from the Visual Basic Editor, the following error message may appear:
Microsoft Access can't communicate with the OLE server.
The OLE server may not be registered.
To register the OLE server, reinstall it.
This is followed by:
There is not enough free memory to update the display. Close unneeded programs and try again.
Closing that error removes the control from the Access form.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Because the UserForm cannot be opened after this problem occurs, the only remedy is to remove the UserForm in the Visual Basic Editor and not use this control on a replacement UserForm.

To remove a UserForm in the Visual Basic Editor, use the following steps:

  1. On the View menu, click Project Explorer.


  2. Click on the plus symbols for the project with the UserForm until the UserForm appears in the Forms folder, and then select the UserForm.


  3. On the File menu, click Remove UserForm<n> (where n is the UserForm number).


  4. If prompted with:


    5. Do you want to export UserForm<n> before removing it?
    click No.

Additional query words: OFF2000 XL2000 PPT2000 WD2000 ACC2000 direct animation user form 


Keywords          : kbdta kbdtacode OffVBA KbVBA 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 29, 1999