Macro Button Font Change possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-3209977%22%20slang%3D%22de-DE%22%3EMacro%20Button%20Font%20Change%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3209977%22%20slang%3D%22de-DE%22%3E%3CP%3EI%20just%20created%20a%20Macro%20with%20a%20button%20and%20a%20text%20belonging%20to%20this%20button.%3C%2FP%3E%3CP%3EI'd%20like%20to%20change%20the%20font%20and%20size%20of%20this%20text.%3C%2FP%3E%3CP%3EI%20haven't%20found%20any%20possiblities%20so%20far.%20Would%20it%20be%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3209977%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3210028%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20Button%20Font%20Change%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3210028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316882%22%20target%3D%22_blank%22%3E%40Hajime_Miura%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERight-click%20the%20button.%20This%20should%20select%20it.%3C%2FP%3E%0A%3CP%3ESelect%20the%20font%20settings%20you%20want%20on%20the%20Home%20tab%20of%20the%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I just created a Macro with a button and a text belonging to this button.

I'd like to change the font and size of this text.

I haven't found any possiblities so far. Would it be possible?

4 Replies

@Hajime_Miura 

Right-click the button. This should select it.

Select the font settings you want on the Home tab of the ribbon.

I just found a solution for the "button."
What I can't find, howevre, is a solusion for the "option field".

@Hajime_Miura 

You cannot change the font of other Form Controls than the Button.

You can change the font of ActiveX controls, but keep in mind that they may cause problems - they are not available on Excel for Mac, for example.

@Hans Vogelaar
Thanks a lot for your information.