Group Box Border

J

Jason

Is there any way to format the group box form control to
hide the border? If not, can you change the color of the
border?
 
C

Chip Pearson

Jason,

Are you talking about a Frame control on a User Form? Set the
BorderStyle property to frmBorderStyleNone.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
P

pikus

If you mean the List Box the BorderStyle and SpecialEffect should be se
to "0". Is that what you mean? - Piku
 
J

Jason

Chip,

Not the frame control. I see how you can remove the
border there. This is called a Group Box - you can get
to it by clicking View | Toolbars | Forms. Its the icon
with the xyz on the top.

I don't see anyway in removing the border or changing the
border color.
 
J

Jason

Chip,

Not the frame control. I see how you can remove the
border there. This is called a Group Box - you can get
to it by clicking View | Toolbars | Forms. Its the icon
with the xyz on the top.

I don't see anyway in removing the border or changing the
border color.
 
C

Chip Pearson

Jason,

I don't think you can change the border properties of that group
box.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

Dave Peterson

You can hide the groupbox via code:

All of them:
activesheet.groupboxes.visible = false

or (one by one)
activesheet.groupboxes("group box 1").visible = false
 
Top