I'm using Excel 2013, and typically I use the default ByVal/ByRef (I haven't needed to change it yet).

The attached file is similar to what I am trying to do (really simplified).

When you open the workbook, it is supposed to populate the listboxes and then select the item you had previously selected.

Then, when you change one of the data sheets, it is supposed to refill in the listbox associated with that sheet, since you might have added or removed a platform choice.

When you select an item in one of the listboxes, it not only links to the cell on UserInput, but also on the data page associated with that listbox.

The populating works, the selection works, but once there is a selection made, it breaks because it sets Sheets("UserInput").AttackListBox to the selected value, where previously it was the object itself.

The formatting is all hosed since I ripped the code from the real model (which, sadly, I can't share).