Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Where to get a visual tree-like object like the one used in the watch-window?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Where to get a visual tree-like object like the one used in the watch-window?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Where to get a visual tree-like object like the one used in the watch-window?

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
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
Watch Window Guilherme Excel Worksheet Functions 0 April 20th 09 02:12 PM
Watch Window Guilherme Excel Discussion (Misc queries) 0 April 20th 09 10:57 AM
VBA Watch Window Adam1 Chicago Excel Discussion (Misc queries) 0 February 24th 05 08:37 PM
Create (or find) a complete object tree for excel Alan Excel Programming 6 February 11th 04 09:34 PM
XL97 watch window hangs Wild Bill[_2_] Excel Programming 0 August 19th 03 08:08 AM


All times are GMT +1. The time now is 10:42 AM.

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

About Us

"It's about Microsoft Excel"