Change User Form Caption Font / Size in Excel 2019

[bisel]

Hello,

I have Excel 2019 and am trying to change the user form caption font / size. When I bring up the user form properties and select the Font, I am afforded the option to change the font properties, however it has no effect when I open the user form in Excel. In fact, there are a couple thing that differ ... for example, the user form does not have a color band across the top anymore.

Is this a "feature" of Excel 2019 (vs 2010) or am I missing something.

Steve

 

[Fluff]

Changing the font simply changes the default setting for any new control you add to the userform.
Not sure you can actually change the caption font/size, but there is a workround here

How to change the UserForm Caption Font

Hi, guys and galls, Please do the following. Create a Userform Change the FONT property: name or size or both What do you expect? I thought that the caption font and size would change. But nothing happens. :confused: Perhaps I am missing the obvious... What's the FONT property made for...

www.mrexcel.com