Consulting

Results 1 to 9 of 9

Thread: I can't find a control

  1. #1
    VBAX Regular
    Joined
    Aug 2019
    Posts
    54
    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 Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    552
    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

    "1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"

  3. #3
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    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 Regular
    Joined
    Aug 2019
    Posts
    54
    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 Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    552
    Location
    Hello ksilenio,

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

    "1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"

  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 Regular
    Joined
    Aug 2019
    Posts
    54
    Location
    Hi Win10 Pro

  8. #8
    VBAX Regular
    Joined
    Aug 2019
    Posts
    54
    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
  •