By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Passing Treeview node.checked values to Excel

P: 1
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
Sep 19 '07 #1
Share this Question
Share on Google+
1 Reply


P: 7
Something simple like this?

Expand|Select|Wrap|Line Numbers
  1. Private Sub TreeView1_NodeCheck(ByVal Node As MSComctlLib.Node)
  2.     Excel.Cells(1, 1) = Node.Checked
  3. End Sub
  4.  
Sep 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.