Passing Treeview node.checked values to Excel

[Farkwark]

I'm using a treeview control with Excel 2003 and VBA.

Can anyone provide a code snippet to show how to, on a treeview node_checked event, pass the node.checked true/false value back to a specific cell on an Excel worksheet?

Thanks

[alan4cast]

Something simple like this?

Private Sub TreeView1_NodeCheck(ByVal Node As MSComctlLib.Node)
    Excel.Cells(1, 1) = Node.Checked
End Sub