Listbox with customisable Property Headings

[BrighterLater]

When one uses a file dialog to select a file, the standard MS windows form contains a multicolumn list box with customisable column headings showing a selection of property names: file name, size, type, etc. Is it possible to incorporate that component of the form in a VBA form. Is this an Activex control that I can use? A link to someone else description would be great. I was unable to find such help I think because I didn't know the search terms to use.

Thank you - Mike

 

[Jon von der Heyden]

Hello Mike

The ListBox ActiveX control supports multi-column and headings. In particular look at its' ColumnCount, ColumnHeads and ColumnWidths properties. NOt sure if this helps but if not can you perhaps explain what exactly you are trying to achieve?

 

[BrighterLater]

Jon

Thank you for replying. I haven't used ActiveX controls before in a form, only the standard VBA controls.

If possible could you give me a link that describes:

1. How I access the activeX control you refer to (do I have to add references to libraries)
2. A description of its methods and properties.
3. Ideally a sample xls containing a simple example.

Just for clarity I'm not expecting you to do all this but if you could give me an MSN link or similar then that would be very helpful.

(What I am trying to achieve is to create an Addin to manage import/export of VBA project components to/from a "workspace" folder. This is so I can use SVN/Tortoise for version control. The most important part of this would be a form containg two multi select list boxes: one for VBA Project Components and the other the folder contents. The Folder contents list would display at minimum, filename, and a (modified) last modified date. A simple multi column list box would suffice but I'd like to know how to mimic the file dialog listbox)

Many Thanks

 

[Jon von der Heyden]

Hi Mike

Ok, first some referrals:

A bit about ListBoxes: http://msdn.microsoft.com/en-us/library/2swkx91x(v=VS.80).aspx

ListBox Control Properties etc: http://msdn.microsoft.com/en-US/library/a08zk9kw(v=VS.80).aspx

The listbox control is the 5th control in the control toolbox (last control 1st row).

Sounds like you're setting yourself quite a task. I never went into the deep end, I discovered ListBox controls capabilities one step at a time here. There's lots of info in historic threads here and the VBA help isn't too bad either.

So, how do you intend on populating the listbox, and once populated what are users going to do with it?