Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TreeView: add more than one node to nodes collection
Hello,
Can somebody help me with this problem. I need to add more than one node to tree in one loop. Becasue if I want to create a tree with 4000 and more nodes, it is slow. I think if I'd allocate memory for all nodes which I want (I know nodes count before creating a tree) it was be faster. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TreeView: add more than one node to nodes collection
Hi Peter,
Can somebody help me with this problem. I need to add more than one node to tree in one loop. Becasue if I want to create a tree with 4000 and more nodes, it is slow. I think if I'd allocate memory for all nodes which I want (I know nodes count before creating a tree) it was be faster. The usual technique for handling tree views with lots of nodes is to populate the child nodes when the user clicks on the parent node to expand it. Other than that, you might find it helps to set the TreeView control invisible before you add all the nodes, then set it visible again afterwards. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TreeView: add more than one node to nodes collection
Hi Stephen, Thanks for interesting of my problem. I try to make a tree invisible, before adding nodes, but it was not reason of my problem. I didn't write in my problem description,that sometimes are 4000 nodes in one level (and already I populate the child nodes when user clicks on the parent node). If you know solution of my problem now, please, mail me back. Thank you Regards Peter *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
TreeView: add more than one node to nodes collection
Hi Peter,
Thanks for interesting of my problem. I try to make a tree invisible, before adding nodes, but it was not reason of my problem. I didn't write in my problem description,that sometimes are 4000 nodes in one level (and already I populate the child nodes when user clicks on the parent node). If you know solution of my problem now, please, mail me back. If you have 4000 nodes at one level, I would suggest that a TreeView is not an appropriate display mechanism - having to scroll through 4000 items to find the one you want would be a nightmare for the users, wouldn't it? One other thing that might be worth trying if you're willing to get down-and-dirty at the API level is Brad Martinez's TVFastLoad example at http://www.mvps.org/btmtz/treeview/ Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing macro from a system by all other nodes on LAN | Excel Discussion (Misc queries) | |||
need to create a node | Excel Discussion (Misc queries) | |||
TreeView in Excel VBA | Excel Discussion (Misc queries) | |||
x-axis dates dont match up with the nodes on the line graph | Charts and Charting in Excel | |||
TreeView Object | New Users to Excel |