+ Reply to Thread
Results 1 to 7 of 7

List View Columns Totals at the end of each column

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2010
    Posts
    77

    Post List View Columns Totals at the end of each column

    Dear's

    I'm using this code for listView
    I need to do 2 things ...
    1- the last 2 columns must have totals at the end of each column
    2- I want to be able to change the width of each column

    any Idea's ??

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: List View Columns Totals at the end of each column

    You want to add the totals to the listview?

    Wouldn't it be better to have textboxes/labels for the totals?

    To change the width of a column use it's Width property.
    If posting code please use code tags, see here.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: List View Columns Totals at the end of each column

    Hello Shacker,

    Here is the amended code to add a totals to the ListView columns.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    04-23-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: List View Columns Totals at the end of each column

    You are GREAT Leith ......

    will try it tomrw when I reach my office


    Thank you Leith

  5. #5
    Registered User
    Join Date
    04-23-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: List View Columns Totals at the end of each column

    Leith ,

    Its giving me a Compile error : Sub or Function not defined
    at IsNummeric
    where it is at
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    04-23-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: List View Columns Totals at the end of each column

    DONE .... Just misspelling for IsNumeric and Totals !!!

    you are so PERFECT Leith

    thanks a lot ...

    WORKING SMOOTHLY
    Appreciated your kind help and support

  7. #7
    Registered User
    Join Date
    04-23-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: List View Columns Totals at the end of each column

    one last thing Leith

    how to remove the brackets and the underline from the totals !

    and if we can add a Balance that = total invoices - total receipts
    and if the balance for payments was more , the balance should appear under the receipts total ...

    statement.jpg

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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