The following example is a realiable way to crash excel 2010.
- Insert Userform with ListBox
- Insert a Table into the same Workbook
- Set the 'RowSource' Property of the ListBox to 'TableName'
- Resize the Table
The resizing causes a freeze, excel will then try to restart but usually doesn't manage to do it. The only way to get out is to x-out the restart menu or restart your computer. You will certainly loose all unsaved progress so please don't do this when working on something.
- Why does this happen?
- How to avoid it/ solve it?
Edit 1: It comes even better! This question states that there is no other way than RowSource to get titles for your MultiColumn Listbox (unless you do it yourself with lables). So either leave a potentially lethal bug in the code or do all headers with your own code..