Can anyone tell me how to use treeview in excel?

Asked By Steve S Billings 0 points N/A Posted on - 07/31/2013

Hi guys,

Can anyone help me by possibly telling me how I can get the treeview in excel to work on a userform?

I am having no luck with this at all. Any code would be helpful also.

Any help with this problem at all would be great.

Thanks in advance.

 

• Status: Open
• Question Views: 1020
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Alexander Jose 0 points N/A #173593

Can anyone tell me how to use treeview in excel?

Steps to use TreeView control in MS Excel:

Create a new workbook and add few formulas to worksheet 1 & 2.

Enter the Visual Basic Editor, and add a new useform to your book.

Add a new blank code module then add the code to launch the useform.

Code: 

Sub ufLaunch ( )

          ‘Launch the useform

          Useform1.Show

End Sub

To add TreeView control to Control Toolbox > Right-Click Toolbox >Additional Controls

Scroll the list and Check Microsoft TreeView Control Version X

This would add up TreeView Control to your Toolbox.

 

About Alexander Jose

Questions
0

Answers
100

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/17/2013
• Question Category: MS Excel