Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Textbox font colour change? | Excel Discussion (Misc queries) | |||
format chart textbox font | Charts and Charting in Excel | |||
textbox font colour | Excel Discussion (Misc queries) | |||
Change colour of font in a textbox? | Excel Discussion (Misc queries) | |||
textbox font size | Excel Worksheet Functions |