Hi Whatsup

Based on the research I did, I think your original post was the best solution. My feeling is that the root cause is just a bug in VBA.

I haven't seen problems with .RowSource although, you do need to be careful to fully qualify the Address of the range; I use .Address(External:=True) to take care of that. Have you noticed specific problems with it when using ListBox, or do you just generally avoid it because of the buggy .Value behaviour?

Never got that far looking for bugs concerning RowSource. There's only one advantage of that property: It allows Columnheads.
If you don't need them, you're much better off using the list-property. It allows you either fill it by arrays or refering to ranges, you can remove, add, modify, ... whatever you want.

If you need headers you might be interested in the ListView-Control, that one even provides additional options - though more difficult to handle than the common ListBox.