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.
Â
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.
Â
