+ Reply to Thread
Results 1 to 5 of 5

Header & Text Alignment in ListView

  1. 06-27-2015, 03:49 PM #1
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Header & Text Alignment in ListView

    Hi,

    I have added column header alignment in userform Listview but it seems doesn't work

    Also, how to centralized list SubItem in List View?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Faridwahidi; 06-27-2015 at 06:02 PM.
    Reply With QuoteRegister To Reply
  2. 06-28-2015, 11:25 AM #2
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Header & Text Alignment in ListView

    as an option you can try this one:
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  3. 06-28-2015, 12:49 PM #3
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Header & Text Alignment in ListView

    Hi john55

    Thanks for the alternative method. If I would like to stick on my own code, what went wrong with this Syntax?
    I want the center text to start on columns 8 and above

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 06-28-2015, 03:36 PM #4
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Header & Text Alignment in ListView

    Thx for yr feedback, I'm sorry, no idea!
    Reply With QuoteRegister To Reply
  5. 06-29-2015, 10:04 PM #5
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Header & Text Alignment in ListView

    Hi John,

    I have resolved

    what I did is changed lvwColumnLeft, lvwColumnCenter to "0" and "2"

    The code remain unchaged
    Please Login or Register  to view this content.
    so, my confusion is the code lvwColumnLeft, lvwColumnCenter is no longer applicable to Align Text ?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Pivot tables column header alignment
    By reedersketer in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2014, 05:50 PM
  2. Formula in Header (Right Alignment)
    By Supriyo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-22-2013, 08:40 AM
  3. [SOLVED] Header and Footer alignment excel 2010
    By BwestOZ in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-25-2012, 09:02 PM
  4. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  5. Problems With Header Alignment When Grouping
    By sliilvia in forum Excel General
    Replies: 0
    Last Post: 07-10-2008, 04:21 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1