Treeview Reference?

[Jeff]

For some reason I can't get my Treeview to work. I've added a
treeview to a form, but when I try and code it, xl doesn't recognize
node. I get the error user-defined variable is not defined. I would
think xl would now what to do with a node, do I need to add a
reference as well?

 

[Guest]

What references do you have (VBE -> Tools -> References). You should have
Microsoft Forms 2.0
Microsoft Windows Common Controls 6.0

Those references should have been automatically added when you put the
treeview on your form but in this case you should check that they are there...

 

[Jeff]

Thanks for that, I'm not finding Microsoft Windows Common Controls 6.0
on my list
of references. I did find mscomctl.osx in my system32 folder. How
can I get this to be recognized? I seem to remember that you do
things like this through (Start->Run) but I'm not sure.

 

[Jeff]

This is pretty weird, anyway I figured it out. I found an old
workbook that had a treeview in it. It had CC 6.0 referenced. So I
kept it open and reopened my wbk I'm working on now and CC 6.0 was on
the list. Thanks for the help.

 

[Robin Hammond]

Jeff,

Just a word of warning.

The common controls could be installed by just about any 3rd party
software - they are often bundled as part of an installation package. The
likelihood is that you will find the controls on about 75% of machines in a
depoloyment situation, BUT, to include the common controls in a project that
you distribute yourself I believe that you need a VB license (not VBA). That
might be why you don't see them as a reference.