I had this Excel crash problem as well. It seems the crash was caused by having the Listbox.RowSource set to the table or range while the code was doing the update work to that table or range.

The crash stopped when I set the Listbox.RowSource to "", updated the data, and then reconnected the Listbox.RowSource to the range. I am actually setting the RowSource = to a ListObject.