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
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.
Sincerely,
Leith Ross
"1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"
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?
Sincerely,
Leith Ross
"1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"
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.