How to SetFocus to ComboBox Embedded in Cell

[yay_excel]

I cannot seem to figure out how to activate an embedded combobox on a worksheet. The SetFocus method is not available as it is for UserForms. I have a DropDown method but that does not actually activate the combobox and if I press the down arrows to attempt to select an item from the list, the active cell moves and the dropdown list stays visible. What am I missing here? Is it not possible to activate an embedded combobox?

[AndyLitch]

Try activate....

[yay_excel]

There is no Activate method either.

[Norie]

How did you create the combobox?

[yay_excel]

Developer tab>Insert>Active X Controls>ComboBox

The formula if I click on the combobox in design mode is =EMBED("Forms.ComboBox.1","")

[Leith Ross]

Hello yay_excel,

Here is a macro that activates "ComboBox1" on Sheet1.

Please Login or Register  to view this content.

[yay_excel]

Ahhh declaring it as an OLEObject solved my issue. Thank you!