I'm using a variable range for my ListFillRange using the Name Manager.

I named a range using this formula:
Please Login or Register  to view this content.
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?