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.

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,
--
Farhad Hodjat


"N.F" wrote:

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.

Hi,

Please refer to the followinf URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu

"N.F" wrote:

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.