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?
Bookmarks