Solved

Tree control in Excel/VBA.

Posted on 2007-03-22
2
522 Views
Last Modified: 2012-08-14

Hello Group,

Is it possible to use a Tree Control in VBA (Excel)? the reason I'm asking this is because I didn't find any tree control on toolbox and also I tried to add a component from the componenet list but the one (aka TV) doesn't have any property that I can use as far as I see.

Your help will be appreciated.

regards,
ak
0
Comment
Question by:akohan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

Accepted Solution

by:
Serena Hsi earned 125 total points
ID: 18773403
Examples of tree controls in Excel:

Using TreeView Control
http://puremis.net/excel/code/080.shtml

The MSDN approach
http://msdn2.microsoft.com/en-us/library/aa155445(office.10).aspx

Sample macro file from dsteppan
http://www.geocities.com/dsteppan/treeview.zip

Using a Treeview Control (another example)
http://www.excelguru.ca/node/85
0
 

Author Comment

by:akohan
ID: 18783604


Good links. Thank you so much.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question