Use the gotfocus method to repopulate

Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = Application.Names("Stuff").RefersToRange.Address
End Sub
--
HTH...

Jim Thomlinson


"QB" wrote:

If I close the workbook and reopen it, it refreshes the item list properly?!
So why doesn't it adjust when I redefine the named range using vba?

QB





"QB" wrote:

I have a cbo which is linked to a named ranged on another sheet.

Using code, the named range gets deleted and the recreated, but the cbo does
not update it list of items to reflect the new named range content. How can
I refresh its list?

QB