Listbox with Categories (code solution)

[JWM6]

I could not find an appropriate ListBox that supported expandable & collapseable categories with items under them (like many File Explorers) and I really needed one with what I was doing.

I did not like the 2 Listbox option - where the first listbox has the categories in it that when clicked shows the items under that category in a second listbox.

I did not want to use an external control or interface with a DLL.........

so I wrote one.... It uses a standard listbox control and the code manipulates categories / items (single level only)

Looks like the following, in the listbox
+ Category One
- Category Two
Item One - Category Two
Item Two - Category Two
+ Category Three

Double clicking a category expands/collapses
Double clicking an item will return the "category * item"
Keyboard methods work as well (up/down, return key)

The init method documents how to add categories and items. After that the code goes about expanding and collapseing. Add your methods for dealing with selected items.

Works for me -- If anyone is interested, I'd be willing to share, PM me.

[royUK]

There is a TreeView control but it's not easy to use

[JWM6]

Is this a part of the toolbox in VBA? Can you point me to it? I searched on various forums and no one mentioned this before.

Thanks,

[JWM6]

I found a post with the appropriate controls that are required for this
Microsoft TreeView Control
but do not have this on my control system, and when I install this on a users system - they may not have it on their system either??? Hmmm....

... and I don't even have this control on my current system - I'm using Excel 2003 to develop.

Thanks,

[royUK]

In the VB Editor insert a UserForm, then in Tools Dialog, right click & select Additional Controls. Scroll down to find the TreeView

[JWM6]

Excellent - thanks.