Can anyone tell me how to use treeview in excel?

Asked By 0 points N/A Posted on -
qa-featured

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.

 

SHARE
Answered By 0 points N/A #173593

Can anyone tell me how to use treeview in excel?

qa-featured

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.

 

Login/Register to Answer

Related Questions