N/APosted on - 07/31/2013
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.
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.
Sub ufLaunch ( )
‘Launch the useform
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.