+ Reply to Thread
Results 1 to 5 of 5

Need help with a Listview in Excel 2007

  1. #1
    Registered User
    Join Date
    09-01-2009
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    25

    Need help with a Listview in Excel 2007

    Hi there, is nice to know that there is a forum where you can get some help to get your job done. My question, and it's my first one here, is regarding the use of ListViews in Excel forms. I need to populate it with a range of several columns with data from a spreadsheet, could you please help me on how can I do that?

    Thanks in advance.
    Last edited by NBVC; 09-01-2009 at 01:38 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,245

    Thumbs up Re: Need help with a Listview in Excel 2007

    You can use the add method of the listitems property to add a row.
    Then the SubItems array to load columns within the row.

    Please Login or Register  to view this content.
    If you need more help post example workbook,
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-01-2009
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Need help with a Listview in Excel 2007

    Thanks a lot, that's exactly what I wanted, it is a good example to carry on with my project. Just one little thing before, how can I add commas to a number to convert it as currency type?

    Again, your help has been very valuable. thanks

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,245

    Re: Need help with a Listview in Excel 2007

    Perhaps the format function will do what you want.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-01-2009
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    25

    Thumbs up Re: Need help with a Listview in Excel 2007

    YOU ARE THE MAN!!! Thanks a lot. Kepp it up with the good work!!!!


+ 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