user form
 

Can you change the caption font size of a user form?

user form
 

Yes. In the properties window for a userform, click on font and it opens a
dialog box to choose the style, size, color, etc. You can also do it by
code.

With UserForm1.Font
.Name = "Arial"
.Size = 12
.ColorIndex = 3
End With



"oldjay" wrote in message
...
Can you change the caption font size of a user form?

user form
 

I tried that myself and when you show the userform the Font size doesn't
change.
--
Cheers,
Ryan


"JLGWhiz" wrote:

Yes. In the properties window for a userform, click on font and it opens a
dialog box to choose the style, size, color, etc. You can also do it by
code.

With UserForm1.Font
.Name = "Arial"
.Size = 12
.ColorIndex = 3
End With



"oldjay" wrote in message
...
Can you change the caption font size of a user form?


.

user form
 

I can't find any properties window that references the caption (the text at
the very top of the user form).

"JLGWhiz" wrote:

Yes. In the properties window for a userform, click on font and it opens a
dialog box to choose the style, size, color, etc. You can also do it by
code.

With UserForm1.Font
.Name = "Arial"
.Size = 12
.ColorIndex = 3
End With



"oldjay" wrote in message
...
Can you change the caption font size of a user form?


.

user form
 

I believe that is a global Windows setting, not an Excel one... I think the
UserForm is just another window, like any other application's window, and
its title bar font properties will be the same as for all the other windows
on a user's system... those properties are settable by the user and I would
think he/she would not appreciate you changing them.

--
Rick (MVP - Excel)


"oldjay" wrote in message
...
Can you change the caption font size of a user form?

user form
 

My mistake. That only applies to text entries on the user form. To change
the Title Bar caption you will have to go to the Appearance feature for
windows. The title bar for the user form is not an Excel application
feature, it is a Windows application feature. When you change it, it
applies to all other workbooks and applications such as Word, Power Point,
Access, etc. You can access the Appearance dialog box by a right click on
your desk top screen and select properties from the pop up menu. Select the
Appearance tab then click the Advanced button. To change features of
windows attributes, click on the object you want to change, in this case the
Active Title Bar. Make your adjustments and click OK.



"oldjay" wrote in message
...
I can't find any properties window that references the caption (the text at
the very top of the user form).

"JLGWhiz" wrote:

Yes. In the properties window for a userform, click on font and it opens
a
dialog box to choose the style, size, color, etc. You can also do it by
code.

With UserForm1.Font
.Name = "Arial"
.Size = 12
.ColorIndex = 3
End With



"oldjay" wrote in message
...
Can you change the caption font size of a user form?


.