Excel VBA Form crash,Mac OS X, Excel 2004 for Mac, version 11.1

G

Guest

An Excel workbook with a somewhat complicated VBA form crashes Excel 2004 for
the Mac as soon as the workbook is opened. The form has a multipage, with
about 200 - 300 Labels, ComboBoxes and Textboxes. This same workbook
functions correctly on Excel X for Mac, and on Excel 2000 on Windows. My
operating system is OS X 10.3.

Here is the text from the Microsoft Excel Error Report:

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2005-01-07 09:21:51 -0500
Application Name: Microsoft Excel
Application Version: 11.1.0.040909
Module Name: fm20
Module Version: 11.1.0.040913
Module Offset: 0x00101b5c
Extra app info: Reg=English Loc=0x0409


Thread 0 crashed:

# 1 0x09c4c6fc in (fm20 + 0x00101b5c)
# 2 0x09c5fdc8 in (fm20 + 0x00115228)
# 3 0x09c5fdc4 in (fm20 + 0x00115224)
# 4 0x09c5f578 in (fm20 + 0x001149d8)
# 5 0x09c29a18 in (fm20 + 0x000dee78)
# 6 0x09ba467c in (fm20 + 0x00059adc)
# 7 0x09c17eb0 in (fm20 + 0x000cd310)
# 8 0x09c601a8 in (fm20 + 0x00115608)
# 9 0x09c5f724 in (fm20 + 0x00114b84)
# 10 0x09c29a18 in (fm20 + 0x000dee78)
# 11 0x09ba467c in (fm20 + 0x00059adc)
# 12 0x09c17eb0 in (fm20 + 0x000cd310)
# 13 0x09c601a8 in (fm20 + 0x00115608)
# 14 0x09c5f724 in (fm20 + 0x00114b84)
# 15 0x09c29a18 in (fm20 + 0x000dee78)
# 16 0x09ba467c in (fm20 + 0x00059adc)
# 17 0x09c17eb0 in (fm20 + 0x000cd310)
# 18 0x09b7b8c0 in (fm20 + 0x00030d20)
# 19 0x09c56e54 in (fm20 + 0x0010c2b4)
# 20 0x09c601a8 in (fm20 + 0x00115608)
# 21 0x09c5f724 in (fm20 + 0x00114b84)
# 22 0x09c29a18 in (fm20 + 0x000dee78)
# 23 0x09ba467c in (fm20 + 0x00059adc)
# 24 0x09c17eb0 in (fm20 + 0x000cd310)
# 25 0x09804318 in (VBE + 0x00037388)
# 26 0x0980452c in (VBE + 0x0003759c)
# 27 0x098040b4 in (VBE + 0x00037124)
# 28 0x0989375c in (VBE + 0x000c67cc)
# 29 0x097e9ba8 in (VBE + 0x0001cc18)
# 30 0x097ea788 in (VBE + 0x0001d7f8)
# 31 0x0988f65c in (VBE + 0x000c26cc)
# 32 0x0988f310 in (VBE + 0x000c2380)
# 33 0x0988efe0 in (VBE + 0x000c2050)
# 34 0x0988e5f4 in (VBE + 0x000c1664)
# 35 0x097cf3a8 in (VBE + 0x00002418)
# 36 0x097cf114 in (VBE + 0x00002184)
# 37 0x097f6960 in (VBE + 0x000299d0)
# 38 0x097f6a30 in (VBE + 0x00029aa0)
# 39 0x097fba90 in (VBE + 0x0002eb00)
# 40 0x097fb8b8 in (VBE + 0x0002e928)
# 41 0x099770dc in (VBE + 0x001aa14c)
# 42 0x098b0e74 in (VBE + 0x000e3ee4)
# 43 0x0994b6e4 in (VBE + 0x0017e754)
# 44 0x0994b724 in (VBE + 0x0017e794)
# 45 0x09963ac8 in (VBE + 0x00196b38)
# 46 0x099553e0 in (VBE + 0x00188450)
# 47 0x019a738c in ( + 0x00000000)
# 48 0x07a36c5c in ( + 0x00000000)
# 49 0x07a36e2c in ( + 0x00000000)
# 50 0x09973560 in (VBE + 0x001a65d0)
# 51 0x09974848 in (VBE + 0x001a78b8)
# 52 0x09974e6c in (VBE + 0x001a7edc)
# 53 0x0997e950 in (VBE + 0x001b19c0)
# 54 0x027beac8 in (Microsoft Excel + 0x007adcb8)
# 55 0x02469ba0 in (Microsoft Excel + 0x00458d90)
# 56 0x0209f718 in (Microsoft Excel + 0x0008e908)
# 57 0x020ab554 in (Microsoft Excel + 0x0009a744)
# 58 0x02057198 in (Microsoft Excel + 0x00046388)
# 59 0x02052be8 in (Microsoft Excel + 0x00041dd8)
# 60 0x02588464 in (Microsoft Excel + 0x00577654)
# 61 0x91683394 in _InvokeAEEventHandlerUPP + 0x00000014 (AE + 0x00013394)
# 62 0x00591030 in (MCPZ.stb + 0x00020c20)
# 63 0x00590db0 in (MCPZ.stb + 0x000209a0)
# 64 0x927d1f9c in _DispatchEventToHandlers + 0x0000014C (HIToolbox +
0x00001f9c)
# 65 0x927d2210 in _SendEventToEventTargetInternal + 0x00000170 (HIToolbox
+ 0x00002210)
# 66 0x927e46b8 in _SendEventToEventTarget + 0x00000024 (HIToolbox +
0x000146b8)
# 67 0x00590cdc in (MCPZ.stb + 0x000208cc)
# 68 0x91674a0c in __Z20aeDispatchAppleEventPK6AEDescPS_mPh + 0x000000CC
(AE + 0x00004a0c)
# 69 0x91677854 in __Z25dispatchEventAndSendReplyPK6AEDescPS_ + 0x00000028
(AE + 0x00007854)
# 70 0x91674c4c in _aeProcessAppleEvent + 0x00000118 (AE + 0x00004c4c)
# 71 0x928c4334 in _AEProcessAppleEvent + 0x00000038 (HIToolbox + 0x000f4334)
# 72 0x02045770 in (Microsoft Excel + 0x00034960)
# 73 0x020454a8 in (Microsoft Excel + 0x00034698)
# 74 0x02017808 in (Microsoft Excel + 0x000069f8)
# 75 0x020121b0 in (Microsoft Excel + 0x000013a0)
# 76 0x02011bf8 in (Microsoft Excel + 0x00000de8)
# 77 0x02010f94 in (Microsoft Excel + 0x00000184)
# 78 0x02829330 in (Microsoft Excel + 0x00818520)

PPC Thread State:
srr0: 0x09c4c6fc srr1: 0x0200f030 vrsave: 0x00000000
xer: 0x20000000 lr: 0x09c5fdc8 ctr: 0x00000000 mq:0x00000000
r0: 0x000000bf r1: 0xbfff5890 r2: 0x06f12000 r3:0x006c0039
r4: 0x000000c0 r5: 0xbfff5b7c r6: 0x09e09b3f r7:0x00000000
r8: 0x00000000 r9: 0x00402004 r10: 0x00000005 r11:0x00000013
r12: 0x5f46556c r13: 0x019c121a r14: 0x06afcff0 r15:0x0000011a
r16: 0x00000000 r17: 0x06f323a0 r18: 0x00000000 r19:0x00000000
r20: 0x00000001 r21: 0x00000000 r22: 0x071f4b90 r23:0x00000000
r24: 0x00000000 r25: 0x09e06650 r26: 0x0000002e r27:0x019f1744
r28: 0x006c0039 r29: 0x00002544 r30: 0x00000000 r31:0xbfff5b78


Thread 1:

# 1 0x90012588 in _clock_sleep_trap + 0x00000008 (libSystem.B.dylib +
0x00012588)
# 2 0x9000d758 in _nanosleep + 0x00000078 (libSystem.B.dylib + 0x0000d758)
# 3 0x9002d388 in _sleep + 0x00000048 (libSystem.B.dylib + 0x0002d388)
# 4 0x02b625e0 in _MerpUnregisterCFMFragment + 0x00000BAC (ShMem +
0x000625e0)
# 5 0x02b61aac in _MerpUnregisterCFMFragment + 0x00000078 (ShMem +
0x00061aac)
# 6 0x02b61bd8 in _MerpUnregisterCFMFragment + 0x000001A4 (ShMem +
0x00061bd8)
# 7 0x02b626b8 in _MerpUnregisterCFMFragment + 0x00000C84 (ShMem +
0x000626b8)
# 8 0x900246e4 in __pthread_body + 0x00000024 (libSystem.B.dylib +
0x000246e4)

PPC Thread State:
srr0: 0x90012588 srr1: 0x0000d030 vrsave: 0x00000000
xer: 0x00000000 lr: 0x9000d758 ctr: 0x90012580 mq:0x00000000
r0: 0xffffffc2 r1: 0xf0080af0 r2: 0xf0080ac4 r3:0x00000507
r4: 0x00000001 r5: 0x00000001 r6: 0x00000000 r7:0xf0080b30
r8: 0x00000000 r9: 0x000059f9 r10: 0x27f3b888 r11:0xa0003ed4
r12: 0x90012580 r13: 0x00000000 r14: 0x00000000 r15:0x00000000
r16: 0x00000000 r17: 0x00000000 r18: 0x00000000 r19:0x00000000
r20: 0x00000000 r21: 0x00000000 r22: 0x00000000 r23:0x00000000
r24: 0x00000000 r25: 0x00000036 r26: 0x000000d8 r27:0x02b724b0
r28: 0xf0080bb0 r29: 0xa00011e0 r30: 0xf0080ba0 r31:0x9000d6f0


Thread 2:

# 1 0x90018be8 in _semaphore_timedwait_signal_trap + 0x00000008
(libSystem.B.dylib + 0x00018be8)
# 2 0x9000e788 in __pthread_cond_wait + 0x00000268 (libSystem.B.dylib +
0x0000e788)
# 3 0x902aa794 in _TSWaitOnSemaphoreCommon + 0x000000AC (CarbonCore +
0x0002a794)
# 4 0x902be6e4 in _TimerThread + 0x00000038 (CarbonCore + 0x0003e6e4)
# 5 0x900246e4 in __pthread_body + 0x00000024 (libSystem.B.dylib +
0x000246e4)

PPC Thread State:
srr0: 0x90018be8 srr1: 0x0000f030 vrsave: 0x00000000
xer: 0x00000000 lr: 0x9000e788 ctr: 0x90018be0 mq:0x00000000
r0: 0xffffffd9 r1: 0xf0101d40 r2: 0x07191ea0 r3:0x0000470f
r4: 0x00004517 r5: 0x00000008 r6: 0x13d26eb0 r7:0xbf392cb4
r8: 0x90282010 r9: 0x00000002 r10: 0xa000a458 r11:0xa0004488
r12: 0x90018be0 r13: 0x00000000 r14: 0x00000000 r15:0x00000000
r16: 0x00000000 r17: 0x00000000 r18: 0x00000000 r19:0x00000000
r20: 0x00000000 r21: 0x00000000 r22: 0x00000000 r23:0x00000000
r24: 0x00000000 r25: 0x00000001 r26: 0x9fffe548 r27:0xa0280b78
r28: 0xa0280bac r29: 0xa00011ac r30: 0xa00011ac r31:0x9000e548


Thread 3:

# 1 0x8fe269c8 in _mach_msg_trap + 0x00000008 (dyld + 0x000269c8)
# 2 0x8fe321d4 in _mach_msg + 0x00000038 (dyld + 0x000321d4)
# 3 0x8fe16504 in _server_loop + 0x00000088 (dyld + 0x00016504)
# 4 0x8fe16334 in _start_debug_thread + 0x00000144 (dyld + 0x00016334)

PPC Thread State:
srr0: 0x8fe269c8 srr1: 0x0000d030 vrsave: 0x00000000
xer: 0x20000000 lr: 0x8fe321d4 ctr: 0x8fe1a968 mq:0x00000000
r0: 0xffffffe1 r1: 0x06ffdcf0 r2: 0x00000000 r3:0x06ffdd90
r4: 0x00000002 r5: 0x00000000 r6: 0x00000040 r7:0x00005903
r8: 0x00000000 r9: 0x00000000 r10: 0x00000000 r11:0x943106a8
r12: 0x8fe1a968 r13: 0x00000000 r14: 0x8fe53254 r15:0x8fe507a0
r16: 0x8fe507d0 r17: 0x8fe5079c r18: 0x8fe507a0 r19:0x06ffddd0
r20: 0x8fe507cc r21: 0x8fe5079c r22: 0x8fe507cc r23:0x8fe53254
r24: 0x06ffdd90 r25: 0x00000040 r26: 0x00005903 r27:0x00000000
r28: 0x00000000 r29: 0x00000000 r30: 0x00000002 r31:0x8fe16490


Loaded modules:

0: Microsoft Excel (11.1.0.040909 Reg=English Loc=0x0409):
/Applications/Microsoft Office 2004/Microsoft Excel
1: PowerPlantZ (11.1.0.040909 Reg=English Loc=0x0000):
/Applications/Microsoft Office 2004/Office/Microsoft Component Plugin
2: MCPZ.stb (11.1.0.040909 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Microsoft Component Plugin
3: MCPCoreZ (11.1.0.040909 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Microsoft Component Plugin
4: Microsoft_Office_2001Z (11.1.0.040910 Reg=English Loc=0x0409):
/Applications/Microsoft Office 2004/Office/Microsoft Office
5: Microsoft Excel (11.1.0.040909 Reg=English Loc=0x0409):
/Applications/Microsoft Office 2004/Microsoft Excel
6: ShMem (11.1.0.040909 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/ShMem.bundle/Contents/MacOS/ShMem
7: afp (1.1.2 Reg=English Loc=0x0000):
/System/Library/Filesystems/URLMount/afp.URLMounter/Contents/MacOS/afp
8: Microsoft OLE X (11.0.0.040322 Reg=English Loc=0x0000):
/Applications/Microsoft Office 2004/Office/Microsoft OLE
9: Microsoft Framework DB (11.1.0.040909 Reg=English Loc=0x0409):
/Applications/Microsoft Office 2004/Office/Microsoft Framework
10: VBE (11.1.0.040913 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Visual Basic for Applications
11: MicrosoftOLE2TypesLib (11.1.0.040913 Reg=English Loc=0x0000):
/Applications/Microsoft Office 2004/Office/Visual Basic for Applications
12: Riched20 (11.1.0.040913 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Visual Basic for Applications
13: fm20 (11.1.0.040913 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Visual Basic for Applications
14: fm20ENU (11.1.0.040913 Reg=English Loc=0x0000): /Applications/Microsoft
Office 2004/Office/Visual Basic for Applications
15: libz.1.1.3.dylib: /usr/lib/libz.1.1.3.dylib
16: AppleShareClientCore:
/System/Library/Frameworks/AppleShareClientCore.framework/Versions/A/AppleShareClientCore
17: DVComponentGlue:
/System/Library/Frameworks/DVComponentGlue.framework/Versions/A/DVComponentGlue
18: dyld: /usr/lib/dyld
19: libSystem.B.dylib: /usr/lib/libSystem.B.dylib
20: CoreFoundation:
/System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
21: CarbonCore:
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCore.framework/Versions/A/CarbonCore
22: IOKit: /System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
23: OSServices:
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/OSServices.framework/Versions/A/OSServices
24: CoreServices:
/System/Library/Frameworks/CoreServices.framework/Versions/A/CoreServices
25: CoreAudio:
/System/Library/Frameworks/CoreAudio.framework/Versions/A/CoreAudio
26: DiskArbitration:
/System/Library/PrivateFrameworks/DiskArbitration.framework/Versions/A/DiskArbitration
27: ApplicationServices:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/ApplicationServices
28: DesktopServicesPriv:
/System/Library/PrivateFrameworks/DesktopServicesPriv.framework/Versions/A/DesktopServicesPriv
29: AppleTalk:
/System/Library/Frameworks/AppleTalk.framework/Versions/A/AppleTalk
30: SystemConfiguration:
/System/Library/Frameworks/SystemConfiguration.framework/Versions/A/SystemConfiguration
31: Carbon: /System/Library/Frameworks/Carbon.framework/Versions/A/Carbon
32: Bom: /System/Library/PrivateFrameworks/Bom.framework/Versions/A/Bom
33: URLMount: /System/Library/PrivateFrameworks/URLMount.framework/URLMount
34: CarbonSound:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/CarbonSound.framework/Versions/A/CarbonSound
35: LangAnalysis:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/LangAnalysis.framework/Versions/A/LangAnalysis
36: ColorSync:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ColorSync.framework/Versions/A/ColorSync
37: SpeechSynthesis:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/SpeechSynthesis.framework/Versions/A/SpeechSynthesis
38: HTMLRendering:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/HTMLRendering.framework/Versions/A/HTMLRendering
39: QD:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/QD.framework/Versions/A/QD
40: AE:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/AE.framework/Versions/A/AE
41: PrintCore:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/PrintCore.framework/Versions/A/PrintCore
42: SpeechRecognition:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/SpeechRecognition.framework/Versions/A/SpeechRecognition
43: OpenScripting:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/OpenScripting.framework/Versions/A/OpenScripting
44: ImageCapture:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/ImageCapture.framework/Versions/A/ImageCapture
45: Help:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Help.framework/Versions/A/Help
46: CommonPanels:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/CommonPanels.framework/Versions/A/CommonPanels
47: Print:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Print.framework/Versions/A/Print
48: SecurityHI:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/SecurityHI.framework/Versions/A/SecurityHI
49: NavigationServices:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/NavigationServices.framework/Versions/A/NavigationServices
50: libCGATS.A.dylib:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libCGATS.A.dylib
51: libCSync.A.dylib:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libCSync.A.dylib
52: libPDFRIP.A.dylib:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libPDFRIP.A.dylib
53: libPSRIP.A.dylib:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libPSRIP.A.dylib
54: libRIP.A.dylib:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libRIP.A.dylib
55: QuickTime:
/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime
56: FindByContent:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/FindByContent.framework/Versions/A/FindByContent
57: Security:
/System/Library/Frameworks/Security.framework/Versions/A/Security
58: LaunchServices:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/LaunchServices
59: CFNetwork:
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CFNetwork.framework/Versions/A/CFNetwork
60: HIToolbox:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/HIToolbox.framework/Versions/A/HIToolbox
61: HIServices:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/HIServices.framework/Versions/A/HIServices
62: CoreGraphics:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/CoreGraphics
63: libcups.2.dylib: /usr/lib/libcups.2.dylib
64: libmathCommon.A.dylib: /usr/lib/system/libmathCommon.A.dylib
65: WebServicesCore:
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/WebServicesCore.framework/Versions/A/WebServicesCore
66: Kerberos:
/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
67: libz.1.dylib: /usr/lib/libz.1.dylib
68: libresolv.9.dylib: /usr/lib/libresolv.9.dylib
69: SearchKit:
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/SearchKit.framework/Versions/A/SearchKit
70: Ink:
/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Ink.framework/Versions/A/Ink
71: libicucore.A.dylib: /usr/lib/libicucore.A.dylib
72: libcrypto.0.9.7.dylib: /usr/lib/libcrypto.0.9.7.dylib
73: libssl.0.9.7.dylib: /usr/lib/libssl.0.9.7.dylib
74: ATS:
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ATS.framework/Versions/A/ATS
75: libbsm.dylib: /usr/lib/libbsm.dylib

Operating System Information
Operating System: Mac OS X 10.3.7 (Build 7S215)
CPU: G5 (970), Number: 1, Speed: 1600 MHz
gestaltPhysicalRAMSize err = 0, result = 1024 MB
gestaltSystemVersion err = 0, result = 0x1037
Screen: 1920 x 1200, depth = 32, ltbr = 0, 0, 1200, 1920

Microsoft Application Information:
Error Reporting UUID: AD722F3A-0D90-11D9-8D8C-000A95C43F1E
Time from launch: 0 hours, 0 minutes, 5 seconds
Total errors on this client: 21
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top