• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Refresh ListFillRange of ComboBox

I want a combobox that updates whenever a button is clicked. I have tried using a dynamic named range along with the .RowSource and .ListCount properties but have had no success.


The combobox lists years that correlate to the present data. When a new year of data gets added, I want the combobox to reflect that when the command button is clicked. I thought that the dynamic named range would take care of this but it does not update automatically.


Is there any way to tell the combobox to refresh its source data?
 
Assuming it's an ActiveX control, right-click, properties. Go to ListFillRange, type the name of your dynamic range. This should allow the dynamic change to occur.
 
Back
Top