Jeffrey Lebowski
Member
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?
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?