CODEWITHSUNDEEP
excelvbacomboboxactivex
Przemyslaw Remin
Przemyslaw Remin

Reputation: 6940

VBA clear ActiveX combobox list

How to clear Excel ActiveX ComboBox list with VBA. I expected this code would work: 

Sheet1.OLEObjects(1).Clear

but it raises

runtime error object doesn't support this property or method.

I am puzzled because this works:

Sheet1.OLEObjects(1).Name

returning the name TempCombo.

I still fail when I try this:

Sheet1.TempCombo.Clear

It returns error:

Runtime error Unspecified error.

What else should I check?

Upvotes: 2

Views: 3136

Answers (2)

Joost
Joost

Reputation: 102

If the combobox has a name, you can just refer to the name. Like

With mySheet
    .cbMyComboBox.ListFillRange = vbNullString
End with

Upvotes: 0

Subodh Tiwari sktneer
Subodh Tiwari sktneer

Reputation: 9966

If you want to clear the ActiveX ComboBox list, you may try something like this...

Sheet1.OLEObjects(1).ListFillRange = ""

Or more precisely this...

If TypeName(Sheet1.OLEObjects(1).Object) = "ComboBox" Then
    Sheet1.OLEObjects(1).ListFillRange = ""
End If

Upvotes: 2

Related Questions