Results 1 to 9 of 9
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Border (square) around ActiveX radio button and check box

    I have an Excel sheet that has both ActiveX radio buttons and check boxes.

    In some cases, two of these might lie on top of one cell, so I can put a border on the cell.

    How can I put a square border around each radio and check option? It seems a text box drawn blocks the use of the button.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kevin,

    If this is what you want:
    kevin1.JPG
    Then Right-Click on the Control and select Format Control:
    kevin2.JPG
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    That would be if I could get that dialog box for ActiveX check boxes and radio buttons. Am I missing something for ActiveX? Obviously.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kevin,

    Can you post a sample workbook?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    See the sample here.
    Attached Files Attached Files

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can add a FORMS group box to act as a border [The forms group box can also be used to separate the separate groups of option buttons]. You can also add a rectangle shape and place it behind the items if you want to have formatting options than just a black outline.

    Steve

  7. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kevin,

    Is there a reason you're using Active-X controls vs regular Form Controls. With regular form controls you can do what you want as I stated in my previous post.
    HTH

    Kevin3.JPG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Correct me if I'm wrong, but if I use form controls and a set of radio buttons, don't they ALL interact with each other?
    I need, for example, 3 sets of 4 radio buttons where the 1st row of 4 can only have 1 selected of the four; the 2nd row of 4 can only have 1; etc.
    I think all radio buttons are treated equally in form controls unless I clearly don't see how to differentiate them as they do with ActiveX.

  9. #9
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kevin,

    You need to put them in "Group Box" for them to act as a unit.
    kevin1.JPG
    Here's a sample file:
    KevinButtons.xlsx
    Note: you can edit out the Group Box title if you wish but you can't get rid of the line. You can however select 3-D shading and it makes the line lighter.
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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