Thread: TextBox Font
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_348_] Leith Ross[_348_] is offline
external usenet poster
 
Posts: 1
Default TextBox Font


Hello Soniya.

You can not change the font of a Forms Toolbar TextBox. By using a
Control Toolbox TextBox (Visual Basic Toolbar) you can control most of
the font properties.

CODE EXAMPLE:

With Worksheets("Sheet1").OLEObjects("TextBox1").Object .Font
..Name = "ML-TTKarthika"
..Size = 8
..Bold = False
..Italic = True
..Underline = False
..Strikethrough = False
End With

TO CHANGE THE FONT COLOR TO BLUE:

Worksheets("Sheet1").OLEObjects("TextBox1").Object .ForeColor = vbBlue

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=489011