How to refer to a combo box in VBA

[pbaxter]

I would like to form a combobox name in code in order to manipulate it:

This won't work:
Sheet1.Comboboxes("combo" & 12).Clear because there's no ComboBoxes collection in Sheet1.

I haven't had any luck using the Shapes or OLEObjects collections.

Any ideas?

TIA,

Paul

 

[GlennUK]

What are you trying to do with Clear? Are you trying to remove the ListFillRange? Or has it been filled some other way?

Sheet1.OLEObjects("ComboBox" & 1).ListFillRange = ""

 

[pbaxter]

Thanks, Glenn.
The OLEObjects method does work, but not for all methods of a combobox. Combobox.Clear is one example.

So I was looking for something like Sheet1.Comboboxes("combo" & 12).

Paul

BTW I'm stealing "Beauty is in the eye of the beer-holder. "