7,788
社区成员
发帖
与我相关
我的任务
分享
Private Sub TreeView1_NodeClick(Index As Integer, ByVal Node As MSComctlLib.Node)
Dim sngSum As Single
sngSum = Val(Node.Text)
If Node.Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Index, Node)
End If
Debug.Print sngSum
End Sub
Private Function fun_SumChildNode(Index As Integer, ByVal Node As MSComctlLib.Node) As Single
Dim i As Integer
Dim sngSum As Single
For i = 1 To TreeView1(Index).Nodes.Count
If Not (TreeView1(Index).Nodes(i) Is Node.Root) Then
If TreeView1(Index).Nodes(i).Parent.Key = Node.Key Then
sngSum = sngSum + TreeView1(Index).Nodes(i).Text
If TreeView1(Index).Nodes(i).Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Index, TreeView1(Index).Nodes(i))
End If
End If
End If
Next i
fun_SumChildNode = sngSum
End FunctionIf TreeView1(Index).Nodes(i).Parent.Key = Node.Key Then
Private Sub TreeView1_NodeClick(Index As Integer, ByVal Node As MSComctlLib.Node)
Dim sngSum As Single
sngSum = Val(Node.Text)
If Node.Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Index, Node)
End If
End Sub
Private Function fun_SumChildNode(Index As Integer, ByVal Node As MSComctlLib.Node) As Single
Dim i As Integer
Dim sngSum As Single
For i = 1 To TreeView1(Index).Nodes.Count
If Not (TreeView1(Index).Nodes(i) Is Node.Root) Then
If TreeView1(Index).Nodes(i).Parent.Key = Node.Key Then
sngSum = sngSum + TreeView1(Index).Nodes(i).Text
If TreeView1(Index).Nodes(i).Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Index, Node)
End If
End If
End If
Next i
End Function
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node)
Dim sngSum As Single
sngSum = Val(Node.Text)
If Node.Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Node)
End If
End Sub
Private Function fun_SumChildNode(ByVal Node As MSComctlLib.Node) As Single
Dim i As Integer
Dim sngSum As Single
For i = 1 To TreeView1.Nodes.Count
If Not (TreeView1.Nodes(i) Is Node.Root) Then
If TreeView1.Nodes(i).Parent.Key = Node.Key Then
sngSum = sngSum + TreeView1.Nodes(i).Text
If TreeView1.Nodes(i).Children > 0 Then
sngSum = sngSum + fun_SumChildNode(Node)
End If
End If
End If
Next i
End Function For i = 1 To TreeView1.Nodes.Count
sngSum=sngSum + TreeView1.Nodes(i)