Results 1 to 4 of 4

Changing Font on Form Controls

This is a discussion on Changing Font on Form Controls within the Excel Questions forums, part of the Question Forums category; Using the “Forms” toolbar, I have put a “Group Box” with 7 “Option Buttons” and a separate “Combo Box” onto ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    3

    Default

    Using the “Forms” toolbar, I have put a “Group Box” with 7 “Option Buttons” and a separate “Combo Box” onto Sheet1 in my workbook. I can edit the text on the “Group Box” and the “Option Buttons” using: [Right mouse click menu] “Edit Text”, but this only lets me change the text that appears on each control. I want to change the font size, how do I do that? Also, after I populate the “Combo Box” with my list, I can’t change the font size of what is displayed in the “Combo Box” control. Can anyone help me?

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,371

    Default

    You're out of luck. You can't adjust the font on controls from the Forms toolbar.

    But you can on controls from the Control Toolbox toolbar.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339

    Default

    I don't think you can change the font style of controls from the forms menu from the default. If you really want to do this, consider using controls from the controls toolbox- you can then modify the fonts etc through right-clicking and selecting Properties. (nb the frame (similar to groupbox) control doesn't appear on mine, you'll need to click on the 'More Controls' button and scroll down to find it under Microsoft Forms 2.0 Frame, or similar).

  4. #4
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539

    Default

    This is the trick, the Group Box is not part of the Object Group so none of the Object properties, like: Bold, Size or Color will work in code or menu options, So;

    Build your Group Box then edit out the lable with spaces matching the number of characters you want in your new lable, then:

    Open the: View-Toolbars-Control Toolbar, select "Lable" drag it in-place of your Group Box caption (now only spaces). Right click the Lable box, select Properies.

    Hit the "Categorized" tab, select "Font" pick your size and bold, change font style if needed. Select "Misc" Name and type your new lable.

    You can click the lable box and fine-tune its lable placement on your group box. If the spaces in the Group Box frame are of the wrong size, move the control lable out of the way and edit the Group Box spaces, reposition the lable box and you are done. You now have a custom labled Group Box. JSW

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com