+ Reply to Thread
Results 1 to 3 of 3

Align Text in a Listbox but diferent for each column

  1. #1
    Registered User
    Join Date
    07-02-2019
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    7

    Align Text in a Listbox but diferent for each column

    Hello everyone.
    i know the property textAlign in a Listbox.
    If i set to Right the columns with numbers looks fine, but not the columns with text.

    żis it possible to align one column to the right and one to the left?


    Thank you for reading

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Align Text in a Listbox but diferent for each column

    It's possible. But it's bit convoluted. I'd recommend using class module method detailed in the link.

    https://wellsr.com/vba/2017/excel/al...rform-listbox/
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-02-2019
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    7

    Re: Align Text in a Listbox but diferent for each column

    Ok.. well it is long but not as hard as I thought
    i really appreciate your time
    Than you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Userform-How to different align text in listbox
    By yardaz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2020, 12:51 AM
  2. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  3. [SOLVED] Sum values beetwen two text in diferent column
    By Ssaamirr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 03:35 AM
  4. [SOLVED] Format align text in column when export to excel with VBA
    By Cuong Pham in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 12:11 AM
  5. Align text box to a column
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2010, 08:18 AM
  6. [SOLVED] How to right-align data in a column of a listbox?
    By Stefano Gatto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2006, 03:40 PM

Tags for this Thread

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