Mahahaava
01-14-2009, 01:30 AM
Hi,
Excel 2003 SP3
Windows XP Pro SP3
Multiple HW sites
Question:
Why does Excel intermittantly "close shop"? I have encountered several situations recently where VBA code is not run unless I either add a MsgBox or run the code through the debugger... My XLS is > 3 MB. Is the code too large or what? Would this be corrected by upgrading to 2008 (or whatever)?
By saying "not run" I mean that no errors are shown but the Sub is not run at all..
Example:
Choosing an index from a dropdown ComboBox will result in the previous index being selected -- run Debugger and the correct index is selected?!?!?!?
Anyone know what the "#?#& is going on?
/Petri
PS XLS size now >3 MB
Excel 2003 SP3
Windows XP Pro SP3
Multiple HW sites
Question:
Why does Excel intermittantly "close shop"? I have encountered several situations recently where VBA code is not run unless I either add a MsgBox or run the code through the debugger... My XLS is > 3 MB. Is the code too large or what? Would this be corrected by upgrading to 2008 (or whatever)?
By saying "not run" I mean that no errors are shown but the Sub is not run at all..
Example:
Choosing an index from a dropdown ComboBox will result in the previous index being selected -- run Debugger and the correct index is selected?!?!?!?
Anyone know what the "#?#& is going on?
/Petri
PS XLS size now >3 MB