+ Reply to Thread
Results 1 to 6 of 6

How Do i Make the Label Controls Caption Text Vertically Center Aligned?

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    I know how to center-align the labels text in the X-Axis i.e. Horizontally, however it looks like, its always Top-Center-Aligned which is not in sync with other controls which are placed at the same level i.e having the same TOP property..

    I want the Caption Text to to be Vertically Center Aligned so that the middles of the other controls are at the same level.

    Warm Regards
    e4excel
    Last edited by e4excel; 05-10-2011 at 01:24 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    You have to change the position of the Label itself - you cannot alter the vertical alignment.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    Romperstomper,

    Very sad to know that ..!

    IS there a way around where I use some otjer controls making it look a Lable is used but which does not have the Top-Aligned Text property to it...

    The Labels are created dynamically and therfore changing the position of one control is not possible if there's any other option of getting the information displayed but with a plain bakgorund would also do...

    Like as IF using a text box with a Plain Background as the User Form

    Warm Regards
    e4excel

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    Yes - use a textbox and format it like a label.

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    Quote Originally Posted by romperstomper View Post
    Yes - use a textbox and format it like a label.
    Dear RS,

    I tried doing that exactly however, even that behaves like a Lable like having the Text Top-Aligned..

    I changed the BackColour to this &H8000000F& and it gets mixed with the User Form however the Alignment is not the same..

    Warm Regards
    e4excel

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How Do i Make the Label Controls Caption Text Vertically Center Aligned?

    It will align with other textboxes though.
    I'm not aware of any controls that allow you to adjust the vertical orientation. I don't really see why you can't adjust the position when you create the control though.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1