excel - Add activex control combo box using VBA

Question

I would want to add a combobox from ActiveX Control using VBA. Whenever I execute the code below, I am able to generate the combo box however, I keep getting a message that says "Can't enter break mode at this time". Why does this happen and how can I avoid this message from appearing?

Below is the code that i used.

Sheets("Data Transfer").OLEObjects.Add(classtype:="Forms.CommandButton.1", Link:=False _
    , DisplayAsIcon:=False, Left:=265, Top:=465, Width:=108.125, Height:= _
    30).Select

question from:https://stackoverflow.com/questions/65661987/add-activex-control-combo-box-using-vba

Answer 1

Waitting for answers