Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping radio buttons on a worksheet (2003)

    I would like to create 2 groups of radio buttons on a worksheet, however each time I create the 2 groups they seem to auto consolidate into one group.

    Is there anything like a frames control for worksheets?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    If you are using the Forms toolbar: you can place Group Box controls on the worksheet. Option buttons within one Group Box act as a group.

    If you are using the Control Toolbox, set the GroupName property of the option buttons. By default, the GroupName is the name of the worksheet, so that all option buttons act as one group. By changing the GroupName property, you can specify several groups.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Hans

    How do you set the group name property when using the control box?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Make sure that you are in design mode.
    Select some option buttons by clicking the first one, then Shift+clicking subsequent ones.
    Click the Properties button on the Control Toolbox.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Hans

    My properties box coming up blank - no headings on the left or seletions on the right, under both alphabetic and catagorized.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    What happens if you keep the Properties window open, then click in the worksheet? You should see worksheet properties. If that works, click on an option button. If not, we'll have to look further.

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Hans

    When testing the sheet as requested in the workbook where the buttons are required, the properties box remained blank. However other new workbooks in which I performed the same test revealed all the properties details.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Is your workbook shared? In a shared workbook, you cannot edit the properties of controls, so the Properties window is blank. You'd have to unshare the workbook first.

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    No the book is not shared - it is also sitting on my computers D drive if this helps.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    I'm probably missing something obvious, but I don't know what would cause the properties window to be blank if the workbook is not shared. What happens if you copy the worksheet(s) into a new workbook?

  11. #11
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    When I copy the sheet into another workbook the properties window appears properly.

    Help!!! There is too much data and code in the original to have to start again or copy it all over.

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    What if you select all sheets (right-click a sheet tab, Select All Sheets), then copy them all at once into a new workbook (Edit | Move or Copy Sheet)?

  13. #13
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping radio buttons on a worksheet (2003)

    Hans

    I asked one of our in house techies to look at this. She too was baffled. She started to copy all the worksheets across from the old file to a new one, while still testing the old file as she went along. Before she finished the copying process the old file started to work properly.


    Alex

Posting Permissions

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