Crashing Excel 2004 : Listbox Bug

E

Edwin Tam

Here is a bug which will cause Excel 2004 to crash. At least, it effectively
crashed all of my clean machines. (HD format, clean install OS X, all patched
installed, Office 2004 full install, all patches applied.)

Description:
For multicolumn listbox control, if list items are added all at once through
an array variable, on Show of the UserForm, Excel 2004 crashes.

Frequency:
For some files, always.

Work Around:
The only fix for such file is to add items to the multicolumn list box one
by one. Never through array all at once.

Sample file:
http://www.vonixx./listbox_crash.sitx

Note:
- This problem cannot be fixed by re-saving the file in Excel X.
- This problem cannot be reproduced by creating a new file in Excel 2004.

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com
 

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