I have a rather involved userform (~350 textboxes spread through a 5
page multipage control) that is populated with data and data analysis
from a SQL query that is attached to a worksheet. It runs fine on my
computer; but crashes on everyone else's computer. The error message
they get is the useless one about e-mailing Microsoft; no line number,
error message or anything to help me track down the issue and the
computers freeze. When I debug the code on a machine that it fails
on, and step through the code which takes a about a minute it works.
I can accelerate that process by running to the cursor after the major
loops and it always works. Subsequent to stepping through the code
once, it always works for the remainder of the session. The user
closes the file and reopens and it crashes; unless I step through the
code once. I have cleaned the code, I have compared the VBA
references and they are all the same, all the computers are running
Excel 2003 SP3. There are only a few hundred rows of data and the
file is only 5M so I don't think it is a hardware limitation on the
other machines. None of the computers have any problem running the
query to get new data or refreshing the query.

I am now totally out of things to even consider that could cause the
failure on everyone else's computers unless they step through the code
first. Does anyone have any ideas?

Thanks

Ken