Results 1 to 3 of 3

Thread: Article: Using a Treeview Control

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider

    Article: Using a Treeview Control

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Hello Ken,
    I am struggling to get this running although the instructions seem to be very clear. First, when you say "Right click the add the following controls" I believe this should read "Left click ...", shouldn't it? Then, when I left-click to draw TreeView, Label and CommandButton, they appear on the VBE screen as in your picture. But when I leave VBE and run ufLaunch, it does not display anything in the treeview although I do have couple of formulas on Sheet1 and Sheet2. It does display Label and the Button. Third, I can not run any other macro from Excel unless I close Userform1.
    What am I missing? I use Excel 2013 on Windows 7 machine.

  3. #3
    OK, I figured out what was the problem. One has to paste Ken's code into the Userform itself, as advised. I pasted it in Module as I was not able to create Module for Userform1. To paste code into Userform1 you have to right-click on Userform1 in VBE, select View code and paste it there.

Posting Permissions

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