Excel List Box Crashes

[mmogul]

I have a spreadsheet that is used as a submission form. On the form, there is a list box. The number of entries on the list (about 25) is greater than the size of the list box area so there is a scroll bar.

This application is used in a number of our offices. At most of the offices, the application works fine. But at a few, when the user selects an entry in the list box and THEN scrolls, Excel crashes with an error:

"Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience"

I tried putting the macro that is called when the user clicks an item in the list box in debug mode. This did not provide any information since the error occurs only when the user scrolls - which is not an event of the list box control.

Does anyone have any suggestions on how to analyze and fix this problem? Could these few machines have a corrupted list box control?

Thanks.

 

[SkipVought]

Hi,

I do not know the reason for this, but I'd first try Help > Detect & repair

Remove all extraneous data and unused sheets.

How many shapes have been placed on your sheet? Be absolutely sure by using code to count the shapes. You may have more than you expected.

In VB, make sure all Excel Objects are set to NOTHING when done.

All variables ought to be appropriately explicitly defined. A variable without a datatype is a variant, which uses alot more memory than it probably needs.

Sometimes the only way to unclog a workbook is to re-create it from scratch. DO NOT COPY SHEETS. Rather, copy the data on each sheet. After you do the rebuild, compare the filesize with the original. In many cases it will be significantly smaller.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}