View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_675_] Leith Ross[_675_] is offline
external usenet poster
 
Posts: 1
Default Text on User form


Hello Dean,

With the VBA editor open, display the form and click on the label you
want to modify. In the Properties window click Font to underline, bold,
etc. the text. To change the font color click on ForeColor and select
the color you want.

These same properties can also be set using VBA code. For example, this
code sets Label1's font to 12 point Arial bold in red...

Label1.Font = "arial"
Label1.Font.Bold = True
Label1.Font.Size = 12
Label1.ForeColor = vbRed

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=563939