ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   tree view control (https://www.excelbanter.com/excel-programming/304494-tree-view-control.html)

Duraiswamy Lingappan

tree view control
 
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





K Dales

tree view control
 
This might help:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/cpref/html/frlrfsystemwindowsformstreeviewclassonbeforee
xpandtopic.asp

-----Original Message-----
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




.



All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com