dynamic range help

[drofnats]

I was trying to setup a dynamic range to be used in
combination with a combo box so it would add/remove rows
when I make changes to my ListFillRange. I'm naming the
range with the OFFSET function, and it sort of works...
When I add a new entry, my combo box won't update
immediately. It requires me to save and close my
worksheet and then reopen it before recognizing the new
entry.

Does anyone know if it's because of one of my combobox
properties (i.e. IMEMode, etc)? or is this just a
limitation of the OFFSET function and something I'll have
to live with?

 

[Debra Dalgleish]

You could use the combobox from the Forms toolbar, which updates
automatically. Or, add code to the combobox's GotFocus event, to update
the list:

'==================
Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "MyRange"
End Sub
'=====================