user form
in [Programming]
|
From: oldjay on 17 Dec 2009 13:26 Can you change the caption font size of a user form?
From: JLGWhiz on 17 Dec 2009 14:05 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" <oldjay(a)discussions.microsoft.com> wrote in message news:91A74F50-379A-42E2-8345-6A027170C287(a)microsoft.com... > Can you change the caption font size of a user form?
From: Ryan H on 17 Dec 2009 14:46 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" <oldjay(a)discussions.microsoft.com> wrote in message > news:91A74F50-379A-42E2-8345-6A027170C287(a)microsoft.com... > > Can you change the caption font size of a user form? > > > . >
From: oldjay on 17 Dec 2009 15:21 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" <oldjay(a)discussions.microsoft.com> wrote in message > news:91A74F50-379A-42E2-8345-6A027170C287(a)microsoft.com... > > Can you change the caption font size of a user form? > > > . >
From: Rick Rothstein on 17 Dec 2009 16:58
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" <oldjay(a)discussions.microsoft.com> wrote in message news:91A74F50-379A-42E2-8345-6A027170C287(a)microsoft.com... > Can you change the caption font size of a user form? |