![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Feb 2002
Location: Massachusetts
Posts: 10
|
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 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
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 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
I think it's called a groupbox if you are using the tools on your worksheet menu bar
|
|
|
|
|
|
#4 |
|
New Member
Join Date: Feb 2002
Location: Massachusetts
Posts: 10
|
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 |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|