user form
in [Programming]
|
From: JLGWhiz on 17 Dec 2009 17:46 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" <oldjay(a)discussions.microsoft.com> wrote in message news:4234CCF7-A140-4EC4-B8D9-03E8114C3B62(a)microsoft.com... >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? >> >> >> . >> |