I want to change the font properties of an option button label.

I am working in Excel Mac 2016, and therefore only have access to Form Control option buttons. The "Format Control > Properties" menu does not have any font options, and I can't find another way to change it.

As I've been unable to do this, I have tried using VBA. The closest I've found is:

ActiveSheet.Shapes("OptionButtonName").OLEFormat.Object.Font.Size = 9

But this does not work. What is the correct way to change the font properties of an option button label?

0 Answers