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

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
.

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