ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formatting text of an option button (https://www.excelbanter.com/excel-worksheet-functions/143985-formatting-text-option-button.html)

Iriemon

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





Rick Rothstein \(MVP - VB\)

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


Rick Rothstein \(MVP - VB\)

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



All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com