I have a user form that is populated using an array. The array is based on
one of two columns. If column B is blank, then column A is used, if column B
contains anything at all, then column B is used to populate the ComboBox on a
user form.

It works fine, except that if a change is made in column B, the change isn't
reflected the next time the user form is loaded. How can I enforce immediate
changes such as this?