Is it possible to expand a selected node with a commandbutton on a userform,if so could
it collapse with the same button?
Z
Is it possible to expand a selected node with a commandbutton on a userform,if so could
it collapse with the same button?
Z
Last edited by zplugger; 01-09-2015 at 08:47 AM.
Hi,
Would you explain in more detail. What do YOU mean by a NODE? What do you mean by EXPAND (the node).
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Sorry
What I mean is say you have the parent node with say 6 child nodes attached. I would like to expand all child nodes from selected parent node with a button.
Are you talking about something like an Organizational Chart for a company.....1 Pres to 6 Vice Pres to 30 Directors etc.?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
You can use the Expanded property.
In your example file add this code. When running select the VBA Code section in order to populate treeview with nodes that can be expanded.
Select Root node and then double click the userform.
The same code can be used in a buttons click event.Please Login or Register to view this content.
Thanks Andy
Works like charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks