|
Posted to microsoft.public.excel.programming
|
|
|
Userform causes Excel to crash
Yes, I do.
"Jim Cone" wrote:
Also, I am betting that you do not have "Option Explicit" at the top of every module?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins: special sorting, comparing, matching, listing, finding...)
"Stu W"
wrote in message
Thanks, Jim. I'll make that change, but that doesn't address the crash
problem.
"Jim Cone" wrote:
modErrorHandle is run every time in each sub.
I don't believe that is actually what you want.
Add "Exit Sub" as a separate line just before the "ErrorRoutine:" line.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
|