Thread: ListBox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Smith[_3_] Paul Smith[_3_] is offline
external usenet poster
 
Posts: 26
Default 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!