Option Button

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I've got 5 questions set up in a form in Excel where I
want to use the Option Button from the Forms menu.
So I set up 5 separate groups so the buttons would behave
independently within the groups. However, how do I get
rid of the border and the text "Group XX"?
 
I think you'll have to use a bit of VBA.

Option Explicit
Sub testme()
ActiveSheet.GroupBoxes.Visible = False
End Sub

Change it to True to see them again--nicer for developing.

==
If you don't use macros, you can select your sheet,
then hit alt-F11 (to get to the VBE)
then hit ctrl-G (to see the immediate window)
then type this and hit enter

ActiveSheet.GroupBoxes.Visible = False

(Same line as the macro.)
 
Back
Top