I have a TreeView control (Treeview1) displayed in excel.UserForm using classic vba.
I wish to return the oNode.text values of those TreeView nodes that are Expanded (not collapsed)
Do I have to detect each node 'expansion' event as it occurs and, for each, write TreeView1.SelectedItem.key to a worksheet,
Could I enumerate the TreeView as follows?
dim oNode as Node
for each oNode in Treeview1.NodeS
... and return to my worksheet the node.key value of each node that is expanded?