ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to Treeview in VBA (https://www.excelbanter.com/excel-programming/299636-how-treeview-vba.html)

kvenku[_9_]

How to Treeview in VBA
 
Hi,
I need to use Treeview control in my VBA code. How to populate th
values for parent and the child.

eg.
Television
Sony
Panasonic
JVC
Philips

I need a '+' sign to be in the treeview for Television.. when i clic
the '+' sign the child values should be visible as the above example.

Also how to get a icon displayed in the treeview for the Parent an
Child list.


Thanks
Venkatesh

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


Tom Ogilvy

How to Treeview in VBA
 
http://support.microsoft.com/default...72&Product=vbb
SAMPLE: TREEVIEW.EXE Manipulating and Saving the Nodes in a TreeView Control

"The purpose of this TreeView sample is to demonstrate the basics of using
and manipulating the TreeView control. This example shows how to add Nodes
using the five different relationship settings of the Nodes Collection Add
Method. It will also allow you to remove a selected Node or branch."


--
Regards,
Tom Ogilvy



"kvenku " wrote in message
...
Hi,
I need to use Treeview control in my VBA code. How to populate the
values for parent and the child.

eg.
Television
Sony
Panasonic
JVC
Philips

I need a '+' sign to be in the treeview for Television.. when i click
the '+' sign the child values should be visible as the above example.

Also how to get a icon displayed in the treeview for the Parent and
Child list.


Thanks
Venkatesh.


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





All times are GMT +1. The time now is 12:32 PM.

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