+ Reply to Thread
Results 1 to 1 of 1

ListView or ListBox for userform?

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 365 v2402
    Posts
    263

    ListView or ListBox for userform?

    I am designing a userform in Excel and was planning on using a ListBox to read in information from a worksheet. The listbox will have multiple columns and contain information about different regions that my company is involved in. Someone mentioned I would be better off using a ListView rather than a ListBox, but I haven't used ListView before.

    Firstly I don't know which one I need. In "Additional Controls" for the VBE Toolbox there are two options: 1) Microsoft ListView Control, version 5 (SP2), and 2) Microsoft ListView Control, version 6.0. I would assume I want 6.0 but I don't know which one is best.

    Is there any benefit to using ListView? I need the ability to allow the user to filter the different columns, for example each work region has a name so need to be able to filter A-Z or Z-A, and different regions have different attributes, for example area size, area population, performance etc. So it would be good to be able to filter each column smallest to largest, largest to smallest etc. I am not sure if this is easier to do in ListView compared to ListBox.

    Basically I want to know what the advantages are (if any) of using ListView rather than ListBox. Are there any?

    Thanks!

    *edit* Also I've just been told that ListView isn't available in 64-bit versions of Excel, e.g. Office365 versions. Anyone know if this true?
    Last edited by TheRobsterUK; 08-10-2017 at 06:25 AM.

+ 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. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  2. Use Listbox/Listview in excel vba userfom to update current record
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2014, 12:37 PM
  3. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  4. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  5. Display all files on a specified path on a listbox/listview with icons
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-02-2012, 10:19 AM
  6. Converting listbox code to work with Listview
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2012, 01:00 PM
  7. VBA - Can I populate a listbox from an array taken from a listview selection
    By PDIreland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2012, 06:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1