From: oldjay on
Can you change the caption font size of a user form?
From: JLGWhiz on
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
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
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
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?