Group Box Border

  • Thread starter Thread starter Jason
  • Start date Start date
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?
 
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
 
If you mean the List Box the BorderStyle and SpecialEffect should be se
to "0". Is that what you mean? - Piku
 
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.
 
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.
 
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
 
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
 
Back
Top