Option Button on Forms vs. Option Button on Control Toolbox
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Option Button on Forms vs. Option Button on Control Toolbox

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Massachusetts
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    i created a couple sets of Options Buttons from the Forms category (NOT the Control Toolbox). Options buttons are like radio buttons.

    in any case, let's say i have 4 buttons, but i want them grouped in 2 sets of 2 buttons each. so if i have buttons 1 & 2 in a set and 3 & 4 in the other set.

    how do i group 1 & 2 together and 3 & 4 together? i want it so that if i click on 1, 2 will be unclicked, but 3 AND 4 remain as is. conversely, if i click on 4, 3 is unclicked, but 1 and 2 remain as is.

    i tried to right click and GROUP, but the GROUP selection is disabled (i.e., greyed out). please offer help! thanks in advance.


    han

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Place each group of buttons in a seperate frame found on your form toolbox.

    Get rid of the frame caption if you want

    K?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think it's called a groupbox if you are using the tools on your worksheet menu bar

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Massachusetts
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    thanks tstom. the groupbox works. i had done the same type of thing a while ago and when i re-visted that file, it looked like i had just put a border around the buttons; i guess i didn't look at it carefully enough. when i re-visited the old file a second time, lo & behold, there was a group box. thanks for the help!

    han

User Tag List

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