Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do I change the formatting of the text in an option button? I would like
to have bold text and different colored text. thanks |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do I change the formatting of the text in an option button?
I would like to have bold text and different colored text. Bold can be handled for any control having a Font property object via the Font's Bold property. From the IDE, highlight the control, click on Font in the Properties window and click the small button with the dot-dot-dot caption, select Bold from the list. In code, you can do it this way... ControlName.Font.Bold = True where ControlName is the actual name of your control. As for the colored text, see these links... http://vbnet.mvps.org/code/subclass/buttoncolour.htm http://vbnet.mvps.org/code/intrinsic...colorcheck.htm Rick |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
IGNORE MY RESPONSE!!!
I made two mistakes in my answer... one, I thought I was in a VB (compiled) newsgroup when I answered and, two, I answered for the wrong control (CommandButton instead of OptionButton). Sorry for any confusion. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Getting value of Option button | Excel Worksheet Functions | |||
Excel 2002: how to incr font size in option button text | Excel Discussion (Misc queries) | |||
How to edit the size and make it bold of the Option Button text? | Excel Discussion (Misc queries) |