Hi
I am try to create a macro with a form and i can't find the tree view control .Can any one tell me where i can find it?
Thank you for your time
Printable View
Hi
I am try to create a macro with a form and i can't find the tree view control .Can any one tell me where i can find it?
Thank you for your time
Hello ksilenio,
You must have the UserForm added to your workbook.
- Open your workbook in Excel.
- Open the VB Editor use ALT+F11.
- Display your UserForm.
- Display the ToolBox ALT+V then press x.
- Right click in a blank area of the Controls tab.
- In the popup menu, Click Additional Controls...
- Scroll through the list for Microsoft TreeView Control
- Click the Box on the left side to select it.
- Click OK and the icon will be added to the Controls tab.
Insert Userform in the VBA project. In the Toolbox window, right-click on any icon and select from the pop-up menu Additional Controls.... In the list find "Microsoft TreeView Control, version X.X. Select it and confirm with OK.
Edit:
Leith faster :)
Artik
Hi
Thank you for your reply
I listened to your instructions but i can't find this control , i find only the tree view control without "Microsoft"
Also i don't have the activeX installer .Is there problem with this?
Thank you for your time
Hello ksilenio,
Which version of Windows are you using?
I'd consider not using the external treeview, but instead using ours: https://jkp-ads.com/Articles/treeview.asp it is completely free and works very good.
Hi Win10 Pro
Hi
I have been visit youe site but from where i'll downlond the control?
Thank you for your time
PLease download the "treeview for Excel" file which is linked to on that page. The file contains elaborate instructions on how to use it in your own userforms.