ListBox
 

I have a listbox that is populated via it's RowSouce which references a
named range on a worksheet.

I have code that adds items to the worksheet and adjusts the named range
accordingly.

Is there a way to have these changes to the RowSource picked up by the
listbox other than unloading and then reloading the form containing the
listbox?

The problem with doing it this way is the choices already selected are lost
when the form is reloaded!