Group Box Border

[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?

 

[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

 

[pikus]

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

 

[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.

 

[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.

 

[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

 

[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