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

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?