Text alignment in User Forms

R

Rob

I have created a user form using VBA, I added a text label. I can change the
text alignment horizontally to fit the center of the label box. How can I
change the vertical Alignment of the text in the label box so it to is in the
middle. Under the behaviour in the Properties box their is no option to align
center vertical.
 
R

Rob Bovey

Rob said:
I have created a user form using VBA, I added a text label. I can change
the
text alignment horizontally to fit the center of the label box. How can I
change the vertical Alignment of the text in the label box so it to is in
the
middle. Under the behaviour in the Properties box their is no option to
align
center vertical.

Hi Rob,

No, there is no vertical alignment option for UserForm labels. You just
have to physically move them up or down to position the text vertically on
the form.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top