Excel error msg: "Microsoft Visual Basic for Applications - User-defined type not defined"

Question

Recently this has happened.  Every time I try to enter data into a cell in Excel, whether it is an old workbook or a new one, I get an error message

This is terribly annoying, as I spend most of my work days on excel.  I have written zero macros for any of the many excel workbooks I have created.  All of the solutions I have read in the google search had to do with macros & coding.

Answer 1

Hello Rick

I am V. Arya, Independent Advisor, to work with you on this issue.

There is a possibility that an Add-in is creating problems. To test this hypothesis, start Excel in safe mode (How to - https://support.office.com/en-us/article/open-o... )

If you don't face the issue, then one of the add-ins will be the culprit. Now you can start application normally and you can disable all of them (File -- Options -- Add-ins) and enable them one by one and check to catch the culprit add-in. .

Next option would be the usual repair to solve any issue with Office installation.

Press Windows key, hold it and press r to open Run window.

Type appwiz.cpl and press enter

This will open Uninstall or change a program window

Click Office in the list of program

Click Change at top

Select Online repair

Restart your computer once Online repair is finished.

Let me know the outcome.