microsoft visual basic for applications error 400

But the library is apparently not accessible. Interestingly enough, the RefEdit library is present on the machine, in the Microsoft Office program directory. If the RefEdit control had been present on the Controls Toolbox, its place may be taken by a gray square with a tooltip of “Unknown”. The RefEdit library is also not found in the list of Additional Controls which can be added to the VBE’s Controls Toolbox. On a computer that experiences the problem, the RefEdit library (refedit.dll) is not available in the references under the VB Editor’s Tools menu,and sometimes it turns up as a MISSING reference in this list. UserForms without RefEdit controls can be viewed with no problems. When the error occurs, it may be impossible to view the UserForm in the VB Editor, or if the UserForm can be viewed, any RefEdits have been stripped off the form.

If a workbook or add-in has a UserForm with a RefEdit, this error may occur. It seems to be related to our old friend, the RefEdit control. Sometimes these occur once, sometimes twice, when Excel is started, when a workbook with code is opened, or when an add-in is opened.Ĭloser examination sheds some light on the problem. To rub salt into the wound, this is followed up with an Out of Memory error:

The error is heralded by an unusually unhelpful error message, even my Microsoft’s standards: Microsoft Visual Basic – System Error &H80004005 (-2147467259). It occurs in Excel 20 (and perhaps in earlier versions, but I don’t recall any such cases). In recent months I have encountered a particularly troublesome error.

Microsoft visual basic for applications error 400