Tags: button, control, dragging, entire, excel, font, forms, handles, increase, microsoft, msdn, resizing, selecting, size, software, text

Change font size in an options button (Forms Control)

On Microsoft » Microsoft Excel

1,761 words with 2 Comments; publish: Thu, 22 May 2008 23:03:00 GMT; (30678.13, « »)

How do I increase the font size of text in an options

button? I have tried resizing the entire control (by

selecting handles and dragging, and using the Properties

box), but it does not change the size of the button or

text associated with it.

All Comments

Leave a comment...

  • 2 Comments
    • After creating the option button, right click it and

      choose Properties. From the list click inside the Font row

      and then click the elipsis (...). A dialog will appear

      where you can change the font size and other attributes.

      tod

      >--Original Message--

      >How do I increase the font size of text in an options

      >button? I have tried resizing the entire control (by

      >selecting handles and dragging, and using the Properties

      >box), but it does not change the size of the button or

      >text associated with it.

      >.

      >

      #1; Thu, 22 May 2008 23:04:00 GMT
    • You can't change the size of the font in an Option button from the Form

      toolbar.

      Instead, you could use an Option button from the Control toolbox.

      (View>Toolbars>Control toolbox)

      Right-click on it, and choose Properties

      Click in the Font property box, click the ... button, and select

      a font size.

      To assign a macro to the Option button, right-click on it,

      and choose View Code

      Type your macro name where the cursor is flashing

      Paul wrote:

      > How do I increase the font size of text in an options

      > button? I have tried resizing the entire control (by

      > selecting handles and dragging, and using the Properties

      > box), but it does not change the size of the button or

      > text associated with it.

      Debra Dalgleish

      Excel FAQ, Tips & Book List

      http://www.contextures.com/tiptech.html

      #2; Thu, 22 May 2008 23:05:00 GMT