| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text on User form
I have some text labels entered directly on a user form and would like to make some of it bold or underline or red font. I don't see how to do this though I imagine there is a way. Can someone help, pls?
Thx! Dean |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text on User form
Ah yes, I see how that works. Thanks!
"Leith Ross" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a new text box to user form | Excel Discussion (Misc queries) | |||
| User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
| user form text box date problems | Excel Programming | |||
| Formatting text in a user form text box | Excel Programming | |||
| User Form Text Box | Excel Programming | |||
![Dean[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
