Hi,

I have a problem in using treeview control in userform.
I have to write some values into different excel sheets by checking the
level.
I am able to get all the nodes using the for loop.

For Each NodX In TreeView1.Nodes
If (NodX.Checked) Then
level = CInt(Left(NodX.Key, 1))
If(level = 2) then
Call processThis(NodX)
End If
End If
Next NodX

In my processThis() method i have get all the nodes which is under that.
1. How i can get all the nodes which is under the passed node?
2. Is it possible to get only the checked nodes using foreach loop?

Thnaks and Regards
Duraiswamy