Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to display information in a tree-like fashion such as use
in the windows explorer and in the Excel VBA watch window. Does anyon know if such "trees" already exist as an ready-to-use object? thanks, Jurry -- Message posted from http://www.ExcelForum.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jurry,
You can use a TreeView control to do this. In the Userform Toolbox window, right-click and choose "Additional Controls" and scroll down (quite far) until you find "Microsoft Tree View Control 6.0". Choose this control and drag it on to you user form. Post back if you have problems programming the nodes of the control. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jurry " wrote in message ... I would like to display information in a tree-like fashion such as used in the windows explorer and in the Excel VBA watch window. Does anyone know if such "trees" already exist as an ready-to-use object? thanks, Jurry. --- Message posted from http://www.ExcelForum.com/ |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks, just 2 more questions:
1) Is it also possible to have next to the tree, columns for value like in the VBA watch window? 2) Is there an internetpage describing how to work with suc treeviews? Jurry -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Watch Window | Excel Worksheet Functions | |||
Watch Window | Excel Discussion (Misc queries) | |||
VBA Watch Window | Excel Discussion (Misc queries) | |||
Create (or find) a complete object tree for excel | Excel Programming | |||
XL97 watch window hangs | Excel Programming |