hiflier
09-05-2010, 12:49 PM
I have a program that does sales, inventory and P&L processing for a very small company. It crashes regularly (screen goes white, round blue circle rotates constantly, need to go CTRL-ALT-DEL to get out of it).
It's Excel 2007 on Win 7 with a capable Toshiba Satellite. I use the .activate to load comboboxes and .deactivate to process changes to a sheet. It looks at .selectionchange to see the active cell name and handle input accordingly. I have a calendar that pops up when in a date cell and a calculator that pops up when in a numeric field.
The only thing I can figure is that Excel doesn't like all the background processing going on. This crash is so pervasive that I'm concerned about using Excel for this at all. What's wrong here? I can't really post all of the code, but I'm looking for a general answer about what in your experience causes Excel to crash like this. Things to avoid. Thanks for your help.
Dave
It's Excel 2007 on Win 7 with a capable Toshiba Satellite. I use the .activate to load comboboxes and .deactivate to process changes to a sheet. It looks at .selectionchange to see the active cell name and handle input accordingly. I have a calendar that pops up when in a date cell and a calculator that pops up when in a numeric field.
The only thing I can figure is that Excel doesn't like all the background processing going on. This crash is so pervasive that I'm concerned about using Excel for this at all. What's wrong here? I can't really post all of the code, but I'm looking for a general answer about what in your experience causes Excel to crash like this. Things to avoid. Thanks for your help.
Dave