Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
Group box border visibility control | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
border color in forms group box | Excel Discussion (Misc queries) |