View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Adding nodes to treeview

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