Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form
Can you change the caption font size of a user form?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
User form ComboBox Items: Remember user entries? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |