Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Treeview control in an Excel form

Can anyone tell me how do you add nodes to a Treeview control, how do you activate its events and retrieve the highlighted node? The properties window doesn't seem to have any Contolsource property or the like. I'm using Microsoft TreeView Control 6.0
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 244
Default Treeview control in an Excel form

You can use the Forms Activate Event to add your node
Me.TreeView1.Nodes.Add.Text = "FirstOne
Me.TreeView1.Nodes.Add.Text = "SecondOne

As far as the events: you should find them in your code window when you select the Treeview's control in the left dropdown box of your code window
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Treeview control in an Excel form

To add child nodes use the Add method of Nodes.
Me.TreeView1.Nodes.Add , , , "FirstOne
Me.TreeView1.Nodes.Add 1, 4, , "A"

----- chris wrote: ----

You can use the Forms Activate Event to add your node
Me.TreeView1.Nodes.Add.Text = "FirstOne
Me.TreeView1.Nodes.Add.Text = "SecondOne


As far as the events: you should find them in your code window when you select the Treeview's control in the left dropdown box of your code window
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Treeview control in an Excel form

For more info on treeview see:
http://www.devx.com/vb/Article/9707/0/page/1

and

http://www.developerfusion.com/show/77/1/

Jurry

--
Message posted from http://www.ExcelForum.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Treeview Control populating Joe O. Excel Programming 2 May 5th 04 01:04 PM
How to use Treeview control with Imagelist kvenku[_2_] Excel Programming 0 April 7th 04 01:52 PM
TreeView Control Andy Excel Programming 0 January 28th 04 12:01 PM
TreeView control Mike Caputo Excel Programming 3 November 14th 03 09:35 PM


All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"