Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this work ??
You need a userform with a treeview control named "Treeview1" before you run
this code.. I don't understand everything seems to work except the Treeview object being passed to the Sub "PopulateChildBranches" Any thoughts would be appreciated. Code starts after this line. Sub RunMe() PopulateChildBranches MyForm, TreeView1, "MyRoot", "L", FilteredLegends End Sub Sub PopulateChildBranches(FormName As UserForm, TreeName As Object, ParentBranch As String, IndexKey As String, StrArray() As String) Dim X As Long Dim NodX As Node For X = 1 To UBound(StrArray) Set NodX = FormName.TreeName.Nodes.Add(ParentBranch, tvwChild, IndexKey & X, StrArray(X)) NodX.EnsureVisible Set NodX = Nothing Next End Sub Dan Thompson. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this work ??
Hi,
what does not work? any error code? which line? First, replace: Set NodX = FormName.TreeName.Nodes.Add(ParentBranch, tvwChild, IndexKey & X, StrArray(X)) by Set NodX = TreeName.Nodes.Add(ParentBranch, tvwChild, IndexKey & X, StrArray(X)) Anyway, we need more inputs to run your code: - what is FilteredLegends - even after the above modification, it breaks on "cannot find element" it's looking for "MyRoot" Reagrds, Sebastien "Dan Thompson" wrote: You need a userform with a treeview control named "Treeview1" before you run this code.. I don't understand everything seems to work except the Treeview object being passed to the Sub "PopulateChildBranches" Any thoughts would be appreciated. Code starts after this line. Sub RunMe() PopulateChildBranches MyForm, TreeView1, "MyRoot", "L", FilteredLegends End Sub Sub PopulateChildBranches(FormName As UserForm, TreeName As Object, ParentBranch As String, IndexKey As String, StrArray() As String) Dim X As Long Dim NodX As Node For X = 1 To UBound(StrArray) Set NodX = FormName.TreeName.Nodes.Add(ParentBranch, tvwChild, IndexKey & X, StrArray(X)) NodX.EnsureVisible Set NodX = Nothing Next End Sub Dan Thompson. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |