View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
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