Hello All,

Newer to the forum. It’s obvious that there are a lot of people here who really know their stuff! Hoping some of that experience can help point me in the right direction on an issue I’ve been struggling with for a while…

I have a data entry dashboard which handles I/O via userform. The userform is launched via image click on the main Excel sheet. Everything works as intended on my PC (which the userform and VBA code were built and debugged on). But once it was released into the wild, it worked perfectly for some users and crashed hard for others. Specifically, when the userform is launched by some users, Excel experiences an APPCRASH event (image). The error handler in the code doesn't intercept whatever the error is.

When the affected user’s file is sent to me via e-mail, I am unable to recreate the crash. When I send the file back to them, the crash doesn’t occur at initial launch, but eventually returns.

I borrowed a user’s laptop that exhibited the problem and set up checkpoints in the VBA code to debug. Here is where it gets a bit strange. I used MsgBox to display when each checkpoint was reached and slowly eliminated them. There is one point in the code where I am able to turn the crash event on / off by including / excluding a MsgBox statement. I have no idea why addition of a MsgBox statement at this point would eliminate the crash, but it is a bit clunky from a UX standpoint. So I am searching for a more permanent solution before rolling out to more users.

Has anybody had experience with anything remotely like this? I’ve been searching the forum but have not found anything quite like it yet… 

Please Login or Register  to view this content.
Error.jpg

Thanks