| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text alignment in User Forms
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text alignment in User Forms
"Rob" wrote in message
... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text alignment in User Forms
Okay, have to move them physically then.
Cheers Bob "Rob Bovey" wrote: "Rob" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected sheet question -- way to allow user to change text alignment and font style? | Excel Programming | |||
| Reading Data from a Cell to a text box-user forms | Excel Programming | |||
| DATA ALIGNMENT- NEW USER REQUIEST HELP; | Excel Discussion (Misc queries) | |||
| DATA ALIGNMENT- NEW USER REQUIEST HELP; | Excel Discussion (Misc queries) | |||
| Align text for labels in user forms | Excel Programming | |||
Linear Mode
