View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mangesh Yadav[_4_] Mangesh Yadav[_4_] is offline
external usenet poster
 
Posts: 101
Default Formatting text of Forms.OptionButton (radio button)

Hi Norman,

Yes, I had seen it.

Mangesh




"Norman Jones" wrote in message
...
Hi Mangesh,

"Mangesh Yadav" wrote in message
...
But then you are not using a control from the FORMS menu, but the

control
toolbox...!





"Norman Jones" wrote in message
...
Hi Rob,

You originally said:

Is there a way to format the text of an OptionButton (from
"Forms")
in
a
macro?

I am not aware of a way to enbolden the caption of an option
button
from
the
Forms toolbar.

If, in fact, you refer to an option button from the Control

Toolbox,
try:

ActiveSheet.OLEObjects("OptionButton1"). _
Object.Font.Bold = True



---
Regards,
Norman