From Controls - Group Box - how can I format this box?

[Jon Johny]

On form controls, for the group box, why are there no formatting options??

Can I remove the group box border?

 

[pgc01]

Hi

I don't think you can format the border of a group box of the form controls. You can, however make it invisible:

ActiveSheet.Shapes("Group Box 1").Visible = False

Although invisible it will still group the controls inside.

(adjust for the group box name)

 

[wthbloop]

I know this was asked... 5 years ago? However, searching for 'remove border option button excel' puts this thread really high up on the results page. Hopefully, this'll help the next person who has this problem.

Ctrl+RMB to select each Option Button, RMB on any of them, then go to Group, Group. You don't actually need a group box (unless you want the visual effect).

 

[CParker1986]

I know this was asked... 5 years ago? However, searching for 'remove border option button excel' puts this thread really high up on the results page. Hopefully, this'll help the next person who has this problem.

Ctrl+RMB to select each Option Button, RMB on any of them, then go to Group, Group. You don't actually need a group box (unless you want the visual effect).

thanks for the help man!