Article: Using a Treeview Control

[Ken Puls]

You can view the page at http://www.excelguru.ca/forums/conte...eeview-Control

[gvg]

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.

[gvg]

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.