Can I Force Re-Evaluation of Dynamic Lists while a Userform is Open?

I've got an unusual problem that may not have a solution, but wondering if anyone knows for sure...

I have a Userform which includes 5 fields that are chosen from a list of, say, 15 choices. The main list (15 choices) is fixed. But, for example, if the user selects "Apples" in the first field, then the dropdown list in the second field will only have 14 choices (with "Apples" removed, so the user can't make the same choice in two of the fields). Likewise, after the user selects the second field, that choice (as well as "Apples") gets removed from the dropdown list for field 3, etc.

In addition, the dropdowns for fields 2 thru 5 show only ONE choice (a "blank", empty choice) until a selection is made in the field immediately before it. This prevents the user from making a selection (for example) in field 2, before field 1 has been entered.

I've already created 5 separate dynamic lists (for the 5 dropdowns), and they function as I've intended. But I have a problem. When the Userform is opened, the lists for fields 2-5 contain only one entry (the blank entry). When the user makes a selection in field 1, the physical list for field 2 is correctly updated (to a 14-entry list), and the named range (that's the RowSource for field 2 in the Userform) is correctly updated from a 1-cell range to a 14-cell range. But apparently the Userform only evaluates RowSource when the Userform is first opened, because the dropdown for field 2 still only shows one entry. It shows the first entry (of the 14 desired choices), but ONLY that first entry. So the Userform thinks RowSource is still referring to the original (1-cell) named range.

Is there any way to force the Userform to re-evaluate the RowSource named range(s) for fields 2-5, while the Userform is open?

Thanks, that was simpler than I expected! But then I'm new to UserForms, so still in the learning stages.
This raises another question, so I'll search for an answer to that, and if unsuccessful, I'll post a new thread for that. Thanks again!

Mehmetcik,
Well, I can't find an answer, and since you specifically recommend using the List property:

Please Login or Register  to view this content.

I'll ask my new question here. I'd like to use a named range to set the ComboBox list. But when I try:

Please Login or Register  to view this content.

(where RangeName is a dynamic range name), I get:

Run-time error '381':
Could not set the List property. Invalid property array index.

So why can't I use a named range to set the List? How do I fix this? I've searched in vain online, and every example I can find simply shows the AddItem method being used to add single items of plain text (like "Bananas"). No examples of using named ranges! Help!

Oh, and as a follow-up, assuming I can figure out how to get my ComboBoxes properly filled (using my named range), if I then want to remove whichever item was selected in ComboBox1 from the list of choices in ComboBox2, do I use:

Please Login or Register  to view this content.

or maybe:

Please Login or Register  to view this content.

or maybe even simply:

Please Login or Register  to view this content.

(I realize that the above would have to be in something like the ComboBox2_Click event, not in the UserForm initialization)