Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 89
Default Formatting text of an option button

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default Formatting text of an option button

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default Formatting text of an option button

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
preserve formatting option in pivot table option dialog box Dave F Excel Discussion (Misc queries) 4 May 8th 08 07:25 PM
keep source formatting is not an option in paste option button Tina Excel Discussion (Misc queries) 0 February 20th 06 09:58 PM
Getting value of Option button BG Excel Worksheet Functions 2 September 27th 05 01:47 PM
Excel 2002: how to incr font size in option button text jdm1051 Excel Discussion (Misc queries) 2 August 15th 05 12:09 PM
How to edit the size and make it bold of the Option Button text? Cammie Excel Discussion (Misc queries) 1 February 23rd 05 01:57 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"