How to hide the Group Box lines around options buttons??

[charlie6067]

I'm working on my first Excel form and need to create option buttons
with Excel's forms toolbar. After making several sets of Group Boxes,
I can't figure out how to remove the Group Box frame surrounding the
option buttons. I know it's something very simple but would appreciate
your help.

Thanks,
Charlie
charlie6067

 

[Dave Peterson]

You can hide the groupboxes in code--I don't think that there's any other way.

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter.

activesheet.groupboxes.visible = false

If you only want to hide a single groupbox, you can use something like:

activesheet.groupboxes("group box 1").visible = false

 

[charlie6067]

You can hide the groupboxes in code--I don't think that there's any other way.

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter.

activesheet.groupboxes.visible = false

If you only want to hide a single groupbox, you can use something like:

activesheet.groupboxes("group box 1").visible = false

Hi Dave - When I reopened the Excel template, the code was missing in
the immediate window. Any ideas? I know I saved it.

Thanks for your help,
Charlie
charlie6067

 

[charlie6067]

Hi Dave - When I reopened the Excel template, the code was missing in
the immediate window. Any ideas? I know I saved it.

Thanks for your help,
Charlie
charlie6067- Hide quoted text -

- Show quoted text -

Dave - I had removed the Enter keystroke by mistake. Added it back in
and it worked fine. Thank you. I really learned something new today.

Charlie
charlie6067

 

[charlie6067]

Dave - I had removed the Enter keystroke by mistake. Added it back in
and it worked fine. Thank you. I really learned something new today.

Charlie
charlie6067- Hide quoted text -

- Show quoted text -

Regarding my last e-mail, everything's working great now. I had made
the Group boxes too narrow and that was not allowing the option
buttons to remain exclusive. After enlarging the Group boxes,
everything works as expected. Many thanks for your help today. I
learned something new which is always a good thing in IT to keep your
job.

Charlie
charlie6067

 

[Dave Peterson]

Glad you got it working.

Regarding my last e-mail, everything's working great now. I had made
the Group boxes too narrow and that was not allowing the option
buttons to remain exclusive. After enlarging the Group boxes,
everything works as expected. Many thanks for your help today. I
learned something new which is always a good thing in IT to keep your
job.

Charlie
charlie6067

 

[DrGreen]

Hi Dave,

Your suggestion on the group box (hiding the lines) helped me also!

Can you tell me ... is there a way in VBE to change the font size ----
I want to make the font larger.

Thank you!!!
Chris.

 

[Dave Peterson]

Change the font size of what?

Hi Dave,

Your suggestion on the group box (hiding the lines) helped me also!

Can you tell me ... is there a way in VBE to change the font size ----
I want to make the font larger.

Thank you!!!
Chris.

 

[DrGreen]

Change the font size of the text that shows up in the box ... the
actual size of the words listed next to the button. The font type and
size buttons are greyed out when entering the name of the button.

Thanks,
Chris.

 

[Dave Peterson]

The caption for the optionbuttons from the Forms toolbar can't be resized.

But you could use the optionbuttons from the control toolbox toolbar and change
the font (and size) in the properties window for each optionbutton.

But these are not grouped the same way.

Each set of optionbuttons in a group has a common groupname property. Different
groupnames mean different groups.

 

[tybaltcap]

Hello:

I tried this earlier today and it worked perfectly. I decided I
wanted the group boxes back on so I typed in
activesheet.groupboxes.visible = true - saved that and then opened it
later and just deleted it out.

Now I dont seem to be able to hide them again. I have followed the
instructions and entered

activesheet.groupboxes.visible = false

I get a runtime error 1004 Unable to set Visiable property of groupbox
class.

Do you know what might be the problem?
Thanks!
Tim

 

[Dave Peterson]

Are you sure that the activesheet had any groupboxes in it?

 

[uyenkieule]

Woohoo! I need to use this today for the group boxes I have in my dashboard and it worked perfectly. Thank you so much! I was trying all different types of methods and nothing worked!

 

[adityapuri23]

Worked Like Charm... Much Appreciated