Is there a way to create a nested ListView in excel 2007?

[BrovashiftExcel]

Hi all,

Still working on my horse racing data project where I am pulling in data from 2 csv files and populating a listview (parent views) with data from Sheet1, and am creating a second listview in the code that is supposed to display data in nested childviews from Sheet2 when Parent View clicked. This works and returns all rows from Sheet2 where horseName = horseName, I can see this in the Locals window when stepping through the code.

I have 2 problems; one is that because I am creating the second (child) listview programatically, and is not a physical control object added to the userform, I dont have access to properties in the property window, and trying to use ChildListView. 'Top', 'Left', 'Width', 'Height' are not recognised. This means that it just creates a very small gray box in the upper most top left corner. Useless!
And the second thing is this is not what I wanted really. Ideally I'd like to have created/used one listview control that has the functionality for a hierarchical structure, parent-child views, but not sure if this is possible in excel 2007.

Is there a better way I can achieve this? If the only option is to created the 'appearence' of nested listviews, then is there another way I can use Top, Left, Width, Height in the code? (commented out here)

Please Login or Register  to view this content.

Or.... is that functionality available in later versions of excel vba? A later version that doesn't require subscription like 365.

TIA

[Marc L]

Or.... is that functionality available in later versions of excel vba? A later version that doesn't require subscription like 365

Hi !

Do you steel believe to Santa Claus ?‼
The future - in fact that already exists - is to use another coding language like Python …

Easy Logic question : why don't you use a second ListView ?!

[PrizeGotti]

I believe that after Excel 2007, support for Listview was removed, as the last update to VBA was VBA 7.1 (2012), which was designed to implement VBA into 64bit versions of Excel, and many things from the 32 bit version were cut.

Nothing with VBA has changed since then, as it's a depreciated language, and while still included in Office, it is no longer supported or licensed by Microsoft.

[BrovashiftExcel]

Thanks for the info guys, I will crack on with what I can. The original idea was using 2 ListViews but I saw nested listview somewhere else and would have liked that ideally, but it's not the end of the world...

I dont understand what you're saying Marc L, are you telling me Santa Claus isn't real?? LOL

I did start making this as a Python web project as it already uses 2 Python web scrapers to aquire the racing data daily for the csv file imports. And looked at using an AWS db to continually store all the data for years to come, and even thought about WindowsForms as I am more familiar with C#. But trying to work with C# to run Python scripts and read csv files to export/import into SQL db on AWS, got really complicated really quick! So decided on a simple userform in excel, as the scraped data is saved as csv and Json>csv, which is easily used inside excel.
Once this is complete with all the bells and whistles I may consider remaking it as a web project, depends on how useful it is and if I want to share it. Possibly not! lol

[Marc L]

using an AWS db to continually store all the data for years to come

Yes that's the best clever safe secure stronger way to store a database,
no matters if Excel crashes, the data are in a safety place …