[VBA] manually-select ActiveX commandbuttons & change font size

[smallxyz]

I need to manually select certain ActiveX commandbuttons on a worksheet, and then change its font size.
Below is my attempted code but returns error.

Sub Testing()
    Dim o As Variant
    For Each o In Selection
        o.Font.Size = 20
    Next
End Sub

Thanks a lot!

 

[smallxyz]

attached a gif.

​

https://imgur.com/a/9kudE4W

 

[Yongle]

The whole of this thread has been about command buttons. It is no wonder you managed to befuddle me. The object in the gif whose text is made bigger is a combobox not a command button
Thank you for the gif

 

[Jaafar Tribak]

I am intrigued - how are you making that work ?
Active-X command button cannot be selected unless user switches to Design Mode but macros are disabled when in Design Mode

Not necessarly true... You CAN actually run code and change the commandbutton attributes even in design mode .

 

[Yongle]

@Jaafar Tribak - agreed - I phrased that rather badly Thanks for the catch