Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,644 questions
Userform throws runtime error 91 when file opened by double-clicking file name but not when opening file using recent histiry from task bar
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 47%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWT%3C/text%3E%3C/svg%3E)
William Thomas
0
Reputation points
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 the file name, 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 task bar 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?
Office
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,904 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,915 questions
{count} votes
-
Viorel 117.4K Reputation points2024-08-03T14:27:10.6733333+00:00 Try to make some changes to UserForm and VBA, save a copy under a different name, close and and reopen it. Maybe it will be auto-repaired.
Are you reading some data from files?
-
William Thomas 0 Reputation points
2024-08-03T14:33:47.0933333+00:00 Not reading from other files, everything is self-contained. I've made several changes trying to change operation. I exported all of the classes and modules and recreated the file under a new name -- all no joy.
It's the fact that the ListBox, when I try to examine it returns 'Nothing' instead of the ListBox class - how can that happen and why is it associated with the method of opening the file?
Sign in to comment
Sign in to answer