Crashing Listboxes

[Bret]

My Excel VBA program has started crashing regularly. I
have narrowed the issue to the listboxes I use on
multiple tabs. When I delete the listboxes, crashing
goes away. The listboxes have their own custom list name
and the fill ranges are from different tabs in the same
workbook. This program is not new, almost 6 months old
so that tells me some combination of steps or code has
manifested this issue. I've been an Excel programmer for
many years and haven't seen this before.

Is there a known issue or bug regarding listboxes for
Excel 2002. thank you.

 

[Norman Jones]

Hi Bret

As a first step, try downloading and running Rob Bovey's CodeCleaner addin:

http://www.appspro.com/Utilities/CodeCleaner.htm

 

[keepITcool]

Bret wrote :

My Excel VBA program has started crashing regularly. I
have narrowed the issue to the listboxes I use on
multiple tabs. When I delete the listboxes, crashing
goes away. The listboxes have their own custom list name
and the fill ranges are from different tabs in the same
workbook. This program is not new, almost 6 months old
so that tells me some combination of steps or code has
manifested this issue. I've been an Excel programmer for
many years and haven't seen this before.

Is there a known issue or bug regarding listboxes for
Excel 2002. thank you.

listboxes as embedded controls on a worksheet?
then Rob 's codecleaner (good as it is) will not help.

but find your temp directory.. and clean out ALL the files in there,
some will be locked by running processes , never mind those.

you'll probably find thousands of emf and tmp files left over from
excel.

should help.

 

[Norman Jones]

Hi KeepItcool,

You are correct - I mis-read the nature of the listboxes!

Notwithstanding my error, the download is a useful addition to one's
toolkit.