Results 1 to 4 of 4

Thread: Using ListView - a Listbox on steroids

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Using ListView - a Listbox on steroids

    I just learned how to use a ListView instead of a normal ListBox. I really luv the way it works. I have uploaded what I used to get familiar with this control. I am sure it can do much more than what I show in my example. So any suggestions/comments on how you use a ListView would be much appreciated. I have used View=3 (this is how the data is displayed) - simply cuz that what what I needed.
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Thanks again for another contribution Rasm

  3. #3
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    btw - I really like how you can re-size the columns from the GUI - also I hooked it up you so you can click in the column header and sort
    xl2007 - Windows 7
    xl hates the 255 number

  4. #4
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    The Listview allows you to have different width per column - also the column width can be re-sized by the user just as in excel itself. Also the Explorebar functionality is there - allowing you to sort by simply clicking the column header
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. Maximum columns in a ListBox
    By Rasm in forum Excel Help
    Replies: 7
    Last Post: 05-04-2020, 12:44 PM
  2. Double click can edition in ListView
    By marreco in forum Excel Help
    Replies: 1
    Last Post: 02-18-2013, 10:09 PM
  3. Change listbox value
    By Tony in forum Excel Help
    Replies: 4
    Last Post: 12-04-2012, 08:58 PM
  4. set ListView on userform
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 12-04-2012, 08:50 AM
  5. Listview not working in Windows 7 - 32 bit
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 07-09-2011, 07:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •