Group Box Border
 

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?

Group Box 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


"Jason" wrote in message
...
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?

Group Box Border
 

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

--
Message posted from http://www.ExcelForum.com

Group Box Border
 

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.
-----Original Message-----
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


"Jason" wrote in
message
...
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?


.

Group Box Border
 

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.
-----Original Message-----
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


"Jason" wrote in
message
...
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?


.

Group Box Border
 

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

"Jason" wrote in message
...
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.
-----Original Message-----
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


"Jason" wrote in
message
...
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?


.

Group Box Border
 

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



Jason wrote:

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.
-----Original Message-----
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


"Jason" wrote in
message
...
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?


.


--

Dave Peterson