G
Guest
How do you add nodes to a treeview control using VBA for Excel?
I've tried the code for VB6
TreeView1.Nodes.Add "MyFirstNode", tvwChild, ,"MyChildNode"
But it is telling me that tvwChild is not declared...
In Excel VBA the quick help for the Add method shows the arguments:
[relative],[relationship],[key],[text],[image],[selectedimage]
but I can't find any documentation as to what syntax to use for these
arguments.
Does anyone know what the syntax for these arguments is for Excel 2002 VBA?
Also, do I need to set a reference to something?
Thanks,
John
I've tried the code for VB6
TreeView1.Nodes.Add "MyFirstNode", tvwChild, ,"MyChildNode"
But it is telling me that tvwChild is not declared...
In Excel VBA the quick help for the Add method shows the arguments:
[relative],[relationship],[key],[text],[image],[selectedimage]
but I can't find any documentation as to what syntax to use for these
arguments.
Does anyone know what the syntax for these arguments is for Excel 2002 VBA?
Also, do I need to set a reference to something?
Thanks,
John