Option Buttons Group Box

[Rod]

I am constructing a questionaire with responses from 1 -
5. After using the "group box" tool to group the option
buttons for a response to the second question, the
response from the first set is eliminated. How do I keep
the responses seperate for each set of questions?

Also, how do I make the border for the group box disappear?

 

[Dave Peterson]

First, did you use the optionbuttons from the Forms toolbar--not the
controltoolbox toolbar?

(it sounds like you may have mixed and matched your controls.)

If you did use optionbuttons from the control toolbox toolbar, you can "group"
them by rightclicking on each one in the group, chosing properties, and then
changing the "groupname" to a unique value (for each group).

If you did use the optionbuttons from the Forms toolbar, are you sure that
they're all within the Groupbox?

And to hide the groupboxes, I think you'll need a line VBA code.

select your worksheet (make it active)
Hit alt-f11 to get to the VBE (were macros live)
hit ctrl-G to show the immediate window

type this and hit enter:
activesheet.groupboxes.visible = false

If (when!) you want to see them again, just change that false to True.