hello I have a treeview set up and would like to use it to call a function in
a module...this is what i have

Private Sub xMytreeview_NodeClick(ByVal Node As Object)

MsgBox Node.FullPath, vbInformation, "path"
'Call Node.FullPath
End Sub

This calls up the msgbox and displays CPAR_Create. I have named my function
in my module as CPAR_Create, unfortunately I get the error that "this object
does not support this property or method"

any help would be appreciated.

Thanks in advance

Call Node.FullPath

Is trying to Call a variable and that is why I used Application.Run in the
other thread.

Also, your original question was about calling 'CPAR Create' not
'CPAR_Create' and that is also why I replaced the spaces with an underscores.

In your original question you also said >>What I would like to
be able to do is call a function in a module when the subcat node is clicked
based on what text is used in the sub node:<< Meaning you only want to call
Child nodes not the Root nodes. That was the reason I did a search for the
Path Separator in the node FullPath. A Root node should not have a Path
Separator in it so ignore it. A Child should have a Path Separator so process
it.


--
A nod is as good as a wink to a blind horse.


"Ryan" wrote:

> hello I have a treeview set up and would like to use it to call a function in
> a module...this is what i have
>
> Private Sub xMytreeview_NodeClick(ByVal Node As Object)
>
> MsgBox Node.FullPath, vbInformation, "path"
> 'Call Node.FullPath
> End Sub
>
> This calls up the msgbox and displays CPAR_Create. I have named my function
> in my module as CPAR_Create, unfortunately I get the error that "this object
> does not support this property or method"
>
> any help would be appreciated.
>
> Thanks in advance

Thanks Chris, got it working...tried the other code...but i kept putting a
comma in where i shouldn't...so it works now...thanks for your time.

"ChrisO" wrote:

> Call Node.FullPath
>
> Is trying to Call a variable and that is why I used Application.Run in the
> other thread.
>
> Also, your original question was about calling 'CPAR Create' not
> 'CPAR_Create' and that is also why I replaced the spaces with an underscores.
>
> In your original question you also said >>What I would like to
> be able to do is call a function in a module when the subcat node is clicked
> based on what text is used in the sub node:<< Meaning you only want to call
> Child nodes not the Root nodes. That was the reason I did a search for the
> Path Separator in the node FullPath. A Root node should not have a Path
> Separator in it so ignore it. A Child should have a Path Separator so process
> it.
>
>
> --
> A nod is as good as a wink to a blind horse.
>
>
> "Ryan" wrote:
>
> > hello I have a treeview set up and would like to use it to call a function in
> > a module...this is what i have
> >
> > Private Sub xMytreeview_NodeClick(ByVal Node As Object)
> >
> > MsgBox Node.FullPath, vbInformation, "path"
> > 'Call Node.FullPath
> > End Sub
> >
> > This calls up the msgbox and displays CPAR_Create. I have named my function
> > in my module as CPAR_Create, unfortunately I get the error that "this object
> > does not support this property or method"
> >
> > any help would be appreciated.
> >
> > Thanks in advance