title: Unspecified Error then Catastrophic Error VBA, may have something to do with listbox?
body: <p>I have been programming small to medium macros in VBA for two years now to improve efficiency within my organization. Excel 2010, saving workbooks as .xlsm.</p>
  
  <p>After 3 days into my current project, I started getting an Unspecified Error, followed by a Catastrophic Error. I can't save, I can't do anything except close the window, when about 5-15 Catastrophic Errors pop up, file is not saved, and I have to pick up where I last saved or autosave kicked in. After it happens once, it happens every 5-30 min until I revert to an older save. Then I get a couple days before it starts happening again. It's ridiculous because this project should take about 1/3 the time it is taking me because of this error. I am only posting now because I can't for the life of me figure out why this error is occurring. I have built much bigger programs before that behave very similarly, but this one keeps crashing. </p>
  
  <p>Some differences from my usual techniques that I have noticed and tried to leverage to pinpoint the problem:</p>
  
  <p>-I am referencing the name of the workbook from a function so that if someone runs this macro from another sheet, it will always do work in the correct sheet</p>
  
  <p>-I am using multiselect listboxes that point to defined tables within excel worksheets. These tables are refreshed often with OLEDB connections and then the listbox is reset via .rowsource property.</p>
  
  <p>-I am using different frames to show/hide a group of controls, all overlapping on the same form (in other macros I've done, different forms exist for different functions)</p>
  
  <p>I don't know if/how any of these things would cause an unspecified/catastrophic error. I am happy to post some code, but I wouldn't know where to start. There's a lot of it.</p>
  
  <p>One more thing, it seems to get hung up with a "Could not set the RowSource property. Unspecified Error" with code -2147467259 at first, and then start crashing a lot after that happens once. I'm not doing anything particularly different when setting the RowSource property.</p>
  
  <p>Any help or ideas would be much appreciated. I have searched a bunch so far with no avail, feeling a bit like <a href="http://xkcd.com/979/" rel="nofollow">http://xkcd.com/979/</a></p>