Consulting

Results 1 to 9 of 9

Thread: I can't find a control

  1. #1
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    5
    Location

    I can't find a control

    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

  2. #2
    VBAX Mentor Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    490
    Location
    Hello ksilenio,

    You must have the UserForm added to your workbook.


    1. Open your workbook in Excel.
    2. Open the VB Editor use ALT+F11.
    3. Display your UserForm.
    4. Display the ToolBox ALT+V then press x.
    5. Right click in a blank area of the Controls tab.
    6. In the popup menu, Click Additional Controls...
    7. Scroll through the list for Microsoft TreeView Control
    8. Click the Box on the left side to select it.
    9. Click OK and the icon will be added to the Controls tab.
    Sincerely,
    Leith Ross

  3. #3
    VBAX Tutor
    Joined
    Dec 2008
    Posts
    277
    Location
    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

  4. #4
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    5
    Location
    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

  5. #5
    VBAX Mentor Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    490
    Location
    Hello ksilenio,

    Which version of Windows are you using?
    Sincerely,
    Leith Ross

  6. #6
    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.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  7. #7
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    5
    Location
    Hi Win10 Pro

  8. #8
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    5
    Location
    Hi
    I have been visit youe site but from where i'll downlond the control?
    Thank you for your time

  9. #9
    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.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •