ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Treeview Reference? (https://www.excelbanter.com/excel-programming/385613-treeview-reference.html)

Jeff[_54_]

Treeview Reference?
 
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?


Jim Thomlinson

Treeview Reference?
 
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...
--
HTH...

Jim Thomlinson


"Jeff" wrote:

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?



Jeff[_54_]

Treeview Reference?
 
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.





On Mar 19, 1:43 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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 thetreeviewon your form but in this case you should check that they are there...
--
HTH...

Jim Thomlinson

"Jeff" wrote:
For some reason I can't get myTreeviewto work. I've added a
treeviewto 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?




Jeff[_54_]

Treeview Reference?
 
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.

On Mar 19, 1:58 pm, "Jeff" wrote:
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.

On Mar 19, 1:43 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-

This-.com wrote:
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 thetreeviewon your form but in this case you should check that they are there...
--
HTH...


Jim Thomlinson


"Jeff" wrote:
For some reason I can't get myTreeviewto work. I've added a
treeviewto 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?




Robin Hammond[_3_]

Treeview Reference?
 
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.

--
Robin Hammond
www.enhanceddatasystems.com


"Jeff" wrote in message
ups.com...
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.





On Mar 19, 1:43 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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
thetreeviewon your form but in this case you should check that they are
there...
--
HTH...

Jim Thomlinson

"Jeff" wrote:
For some reason I can't get myTreeviewto work. I've added a
treeviewto 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?







All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com