UserForm dependent dropdown menus refresh

[tmahbubani]

Hello,

I have put together a user form with two ComboBoxes, one dependent on the other. The first box has a drop down menu from which the user selects a name, and the second drop down populates a list from a named range according to the user's selection in the first box. The code I used is as follows:

Please Login or Register  to view this content.

This has worked so far, however, if one selects a name in ComboBox1 and then changes their selection (ex. Initially selects John Smith from the first menu, and then changes their selection to Mike Roberts) there is an error. I am not sure why - I think the issue stems from the 'Clear' function but I am not sure how to resolve it.

Thanks!

[Tinbendr]

You can't .Clear a combobox that is tied to a rowsource.

The first time the code runs, it assigns the rowsource. When it runs again, a rowsource has been already be assigned.

You have to remove the rowsource first, then use clear.

Please Login or Register  to view this content.

[tmahbubani]

Thank you so much that worked perfectly!!