Userform throws runtime error 91

**CaptDunsel** · 08-04-2024, 03:06 PM

I have a file that was uses a common Userform for list selections. If I open the file by going to the folder where it resides and double-click on the file name to open the file, the Userform code throws runtime error 91 when it reaches a line of code involving the ListBox on the form. The debugger shows the ListBox as 'Nothing' when I put it in the watch window. However, if I open the exact same file from the Excel recent history, it works as intended.

The errors only occur on a computer running Office 365. If I run the exact same code on a computer running Excel 2013, it runs as intended regardless of how I open the file.

What is going on and how do I get the correct behavior by double-clicking the file name?

**6StringJazzer** · 08-04-2024, 06:58 PM

Welcome to the Forum CaptDunsel!

The problem you are describing is not common enough that we know the answer without being able to see your file. It's not common at all. In fact it may be unique.

Error 91 means you are referencing an object that has not been set; you have confirmed that by showing it's Nothing. That shouldn't happen with a control on a UserForm, unless you are doing things like dynamically creating or deleting controls.

I would suggest that you attach your Excel file here. Remove any private data, and explain how we run your code and steps to get to where the error occurs.

If you don't attach the file, at a bare minimum we need to see all of the code in your entire file.