Howdy
I've got a dynamic named range as the source for a combobox. When the range
is added to or deleted (which the dynamic named range correctly adjusts to),
I need to combobox to also have the new values added or deleted. I thought
Excel would do it itself.
how do I get them to update?
Thanks a lot
matt

Not that hard is it?
Matt

"Matt Jensen" wrote in message
...
Howdy
I've got a dynamic named range as the source for a combobox. When the
range
is added to or deleted (which the dynamic named range correctly adjusts
to),
I need to combobox to also have the new values added or deleted. I thought
Excel would do it itself.
how do I get them to update?
Thanks a lot
matt

Maybe you could use a worksheet_change event to update that combobox's list.

Or maybe you could update the list when you click on the combobox.

I put a combobox from the Control Toolbox toolbar on a worksheet and used this
code.

Option Explicit
Private Sub ComboBox1_GotFocus()
Me.ComboBox1.ListFillRange = ""
Me.ComboBox1.Clear
Me.ComboBox1.List = Me.Range("test1").Value
End Sub

But one of the reasons you didn't get a reply is your question is lacking
specifics.

Where is your combobox? On a worksheet or on a userform.
If it's on a worksheet, is it a combobox from the control toolbox toolbar or a
dropdown from the Forms toolbar.

Without specifics, lots of people will just go to the next question.

If my response isn't close, post back with more details.

Matt Jensen wrote:

Not that hard is it?
Matt

"Matt Jensen" wrote in message
...
Howdy
I've got a dynamic named range as the source for a combobox. When the
range
is added to or deleted (which the dynamic named range correctly adjusts
to),
I need to combobox to also have the new values added or deleted. I thought
Excel would do it itself.
how do I get them to update?
Thanks a lot
matt



--

Dave Peterson

Awesome!
That'll do just fine I imagine.
Sorry, tried to keep it simple, I now realise I should've specified toolbar
source and location of combobox (worksheet and control toolbar as you
guessed).
Great
Thanks
Matt


"Dave Peterson" wrote in message
...
Maybe you could use a worksheet_change event to update that combobox's
list.

Or maybe you could update the list when you click on the combobox.

I put a combobox from the Control Toolbox toolbar on a worksheet and used
this
code.

Option Explicit
Private Sub ComboBox1_GotFocus()
Me.ComboBox1.ListFillRange = ""
Me.ComboBox1.Clear
Me.ComboBox1.List = Me.Range("test1").Value
End Sub

But one of the reasons you didn't get a reply is your question is lacking
specifics.

Where is your combobox? On a worksheet or on a userform.
If it's on a worksheet, is it a combobox from the control toolbox toolbar
or a
dropdown from the Forms toolbar.

Without specifics, lots of people will just go to the next question.

If my response isn't close, post back with more details.

Matt Jensen wrote:

Not that hard is it?
Matt

"Matt Jensen" wrote in message
...
Howdy
I've got a dynamic named range as the source for a combobox. When the
range
is added to or deleted (which the dynamic named range correctly
adjusts
to),
I need to combobox to also have the new values added or deleted. I
thought
Excel would do it itself.
how do I get them to update?
Thanks a lot
matt



--

Dave Peterson