Updating a combo box's named range in excel

[Zubinsum]

Hello. I was hoping someone out there could help me with an excel combo box problem I am having.

I have a combo box that refers to a named range "x" in excel. I also have a a macro that adds a new cell to that named range ("x&quot when a user so desires.

However, upon updating that range in excel, the drop down list the combo box refers to is not updated. I have noticed however when I reload the sheet, the combo box is updated.

I have played with the combo box properties, with no sucess. I did think that I may need to reload my combo boxes in my macro, but I am not sure how to do this or if this is even possible.

Can anyone offer any advice? Is there a way around this? Is there a way to update (or reload) a combo box without reloading the workbook?

-Zubinsum

 

[Sypher2]

Hmmm... Have you tried throwing in a ComboBox.Update at the end of your macro code?

 

[Zubinsum]

I get a

"runtime error '424'
object required"

 

[Sypher2]

Replace ComboBox with whatever you named the actual combobox.

 

[Zubinsum]

The ComboBox is named ComboBox1... I get the same error.
Am I doing this right? Is the command line that you suggest at the end of the macro:
"ComboBox1.Update"?