I'm using a variable range for my ListFillRange using the Name Manager.
I named a range using this formula:
I put the NAME of this into the ListFillRange of the ActiveX combobox. However, the list only updates into the combobox when I close and reopen the workbook. Is there any way to fix this?
Thanks!
P.S. I've heard that ActiveX is unstable. But it's my only option to have a large font within the combobox. So, is there a code I can add to do something to the combobox to refresh, or whatever (closing and reopening) does to it?
Bookmarks