Select a Node in a TreeView with VBA

Question

I have a TreeView within a UserForm in Excel. When a Node is selected from the TreeView, a ListBox is populated with data.
When an item in the ListBox is double-clicked, a separate UserForm is shown which allows the user do to stuff.
Once the user returns back to the TreeView UserForm, I want the Node that was selected previously to be highlighted.

The problem is that the UserForm basically resets itself, and I can't figure out how to select a Node with VBA.

I'm at the point where I'm debating on whether or not I can just manually fire a NodeClick event, as everything else I've tried has failed.

Any tips?

Answer 1

I know this is an old question but i had trouble enough finding a decent answer myself so here we go. Index or Key's are not always available. On create I place the fullpath of the node in the node.tag. On double-click I recall the tag value, later on I search the treeview node collection for the tag. To much? not efficient? maybe but its works likes a charm every time and i can use my own identifiers in the tag based on the purpose of the treeview. The find code:

Sub MyTreeview_FindNode(strKey As String)
Dim myNode As Node

   For Each myNode In Me.Treeview.Nodes
       If myNode.Tag = strKey Then
          myNode.Selected = True
          myNode.EnsureVisible
          End If
       Next
End Sub 

Answer 2

In my Excel works:

TreeView1.Nodes(key).Selected = True