Thread: user form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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?