Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frame Border Color
Hey guys,
In VBA, when you add a frame to a userform, it creates that default greyish color bording the frame. I accidentally changed the BorderStyle property to 1 - fmBorderStyleSingle from 0 - fmBorderStyleNone. When I tried to change it back, it didnt go back to the way it originally was(that default greyish color around the frame). Instead, now you cant even see the frame border. How do I get it back to the way it was before I changed it by mistake? Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frame Border Color
Oh I got it, its special effect etched
-----Original Message----- Hey guys, In VBA, when you add a frame to a userform, it creates that default greyish color bording the frame. I accidentally changed the BorderStyle property to 1 - fmBorderStyleSingle from 0 - fmBorderStyleNone. When I tried to change it back, it didnt go back to the way it originally was(that default greyish color around the frame). Instead, now you cant even see the frame border. How do I get it back to the way it was before I changed it by mistake? Thank you Todd Huttenstine . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frame Border Color
Todd,
When you change the BoprderStyle property, the Special Effect property also gets changed to frmSpecialEffectFlat.. Change it backto frmSpecialEffectEtched, and it will be as you expected. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Todd Huttenstine" wrote in message ... Hey guys, In VBA, when you add a frame to a userform, it creates that default greyish color bording the frame. I accidentally changed the BorderStyle property to 1 - fmBorderStyleSingle from 0 - fmBorderStyleNone. When I tried to change it back, it didnt go back to the way it originally was(that default greyish color around the frame). Instead, now you cant even see the frame border. How do I get it back to the way it was before I changed it by mistake? Thank you Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Frame cells with Outline Border | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
Excel Sheet - Hidden Border or Frame | Excel Discussion (Misc queries) |