![]() |
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? |
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? |
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? |
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? |
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