ComboBox2.Clear ComboBox3.Clear End Sub How to fill the 2nd list? When a value is selected in the first drop-down list, it will (the text shown in the Combobox) correspond to a workbook name. To ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.