+ Reply to Thread
Results 1 to 5 of 5

Align in ListBox vba

  1. #1
    Registered User
    Join Date
    05-06-2012
    Location
    Lisbon,Portugal
    MS-Off Ver
    Excel 2010
    Posts
    79

    Align in ListBox vba

    Hi everybody.
    A have a listbox with multicolumns in userform. The question is:
    Are there any property relating to "listbox" that allows to align a multiColumns text?
    Thanks a lot

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Align in ListBox vba

    See next message.
    Attached Images Attached Images
    Last edited by Tinbendr; 03-12-2013 at 06:01 PM.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Align in ListBox vba

    Not for each column. About the best you can get is to set the starting column index of each column.
    Columns.GIF

  4. #4
    Registered User
    Join Date
    05-06-2012
    Location
    Lisbon,Portugal
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Align in ListBox vba

    Hi David
    I really appreciate your quick help, I already used that solution, but the problem is the 2nd, 3th ...Columns. Have you any idea?
    Thank you for advance
    Carlos

  5. #5
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Align in ListBox vba

    You can align columns in a listview control... Except, strangely enough, the first column. That must be the usual left aligned.

    Maybe not a useful answer if you never heard of it as it's got a steep learning curve.

+ 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