PDA

View Full Version : I can't find a control



ksilenio
08-25-2019, 08:39 AM
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

Leith Ross
08-25-2019, 01:05 PM
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.

Artik
08-25-2019, 01:07 PM
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

ksilenio
08-26-2019, 11:28 AM
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

Leith Ross
08-26-2019, 02:55 PM
Hello ksilenio,

Which version of Windows are you using?

Jan Karel Pieterse
08-27-2019, 08:28 AM
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.

ksilenio
08-27-2019, 11:30 AM
Hi Win10 Pro

ksilenio
08-27-2019, 01:56 PM
Hi
I have been visit youe site but from where i'll downlond the control?
Thank you for your time

Jan Karel Pieterse
08-28-2019, 01:36 AM
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.