View Full Version : Solved: Populating treeView
Kaizer
02-24-2006, 02:09 AM
Le me ask you on the treeView. I have a sheet with three columns that will have to be used for populating the treeView. Column A has only one value = "EMEA". This will be the First parent in the tree view. Column B has Regions that belong to EMEA. This should be second Parent in the treeView. Column C has countries that belong to the regions. This is the child for the treeView. My question is how to populate the treeView using the code? I attach the file with the Form and treeView on it and the Data sheet. Can you help?
Bob Phillips
02-24-2006, 02:44 AM
Here you are
Kaizer
02-24-2006, 03:03 AM
Thanks xld. That's what I need! :)
Kaizer
02-24-2006, 03:11 AM
XLD, I just noticed that not all the countries were populated. For example Italy region should include two countries. And it's not the case in the attached file.
Bob Phillips
02-24-2006, 03:47 AM
Logic error
Kaizer
02-24-2006, 03:49 AM
Great, thank you. :)
Bob Phillips
02-24-2006, 03:53 AM
One thing, you have two categories, Actual and Budget, and some countries are only in one category. The code I gave will pick up the value from actual, but any in Budget not in Actual will also be picked up. Is that what you want?
Kaizer
02-24-2006, 03:56 AM
Yes, I need the countries for all the categories.
Bob Phillips
02-24-2006, 07:09 AM
Yes, I need the countries for all the categories.
Pkay then, it should be alright as is.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.