clear data bound combobox when userform is shown

[pjbassdc]

Hi all,

Been running myself in circles with this. It seems a no-brainer but I can't seem to get it to work out. I have a userform with a contol box. When I click the control it will hide the userform and show another. Simply put, I want the shown userform to have its only combobox (Combobox1) clear itself of previously entered data. I have the combobox tied to a named range from which I can make a selection. I have tried variations along the line of Combobox1.clear, Combobox1.text.clear, Combobox1.value ="" and so on.

Please help.

Thank you,

Patrick

[jaslake]

Hi Patrick

You can try this

Private Sub UserForm_Activate()
    Me.ComboBox1.ListIndex = -1
End Sub

[pjbassdc]

Worked like a charm. Thank you very much.

Patrick

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.