I have a combobox on a userform that is populated via a RowSource which is a dynamic Named Range. If I delete one of the entries in the Named Range the Named Range address changes as it should, but how to I get the combobox to refresh dynamically, in other words without having to close and reopen the userform?