Combobox

N

N.F

Thanks to all who are willing to help

I have a combobox that gets the items in it from a range. The range however
is sometimes expanded to cover more items. I cant make the combobox to show
these new added items. What should I do to let the combobox know that it
needs to update.
 
F

Farhad

Hi,

You can name your range as dynamic name so if you add in the end of your
list it comes to you name range to make a dynamic name go to:
Insert> Name> Define

put the name in the top textboex (say MyDynamicName)
and put the following frmula to the refer to text box at the bottom ( asumed
your range starts from the cell A1)

=OFFSET($A$1,0,0,COUNTA(OFFSET($A$1,0,0,9999,1)),1)
link your combobox to the name

Thanks,
 
Top