Refreshing a ActiveX combo box
 

Hi Folks,

I have an activeX combo box which is populated by the contents of a range
called "ClientList". That works fine, and includes all items in the range.

When I add a new line to ClientList and rename the range, the update is not
reflected in the combo box until the workbook is closed and then re-opened.

Is there a way to correctly repopulate the combo box with the new updated
ClientList without closing and opening the workbook?

Thanks in advance,

Paul Silverman
Melbourne Australia