View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
MerseyBeat MerseyBeat is offline
external usenet poster
 
Posts: 16
Default Vertically centering text in a label field

Would adjusting the text font size and/or height property of the label
suffice?
Changing those properties may give the text the "appearance" of being
centered.

MB

"mondrogan" wrote in message
...
In a userform, I sometimes prefer using a label instead of a textbox,
because the label can't be edited and is automatically gray. Basically I
want to use the label field just as if it were a textbox that can't be
edited and is always grayed out.

The problem I have is that the caption (font) in the label is not centered
vertically in the box. It looks to be aligned at the top, and I can't see
any way to change it. Maybe not a big deal, but the letters don't line up
with other textboxes on the same line and it makes the userform look bad.

Does anyone know how I can center the label caption vertically within the
label field?