I am looking for a good resource for the TreeView Control in VBA. Can anyone
recommend one? In the mean time I have a question.

1) How do disable the users ability to change the Text property of the node
once the userform initializes? For example belwo the text property is "Child
11". Once the Tree form pops up, the user can single-click on "Child 11" and
change the text (like changing file name when single-clicking in folder tree
in Windows). I don't want the user to have this option.

Set nodX = .Add("C1", tvwChild, "C11", "Child 11")

Thanks

EM

The .LabelEdit property ?

NickHK

"ExcelMonkey" wrote in message
...
I am looking for a good resource for the TreeView Control in VBA. Can
anyone
recommend one? In the mean time I have a question.

1) How do disable the users ability to change the Text property of the
node
once the userform initializes? For example belwo the text property is
"Child
11". Once the Tree form pops up, the user can single-click on "Child 11"
and
change the text (like changing file name when single-clicking in folder
tree
in Windows). I don't want the user to have this option.

Set nodX = .Add("C1", tvwChild, "C11", "Child 11")

Thanks

EM

perhaps
..SingleSel = True

br Jim

"ExcelMonkey" skrev i melding
...
I am looking for a good resource for the TreeView Control in VBA. Can
anyone
recommend one? In the mean time I have a question.

1) How do disable the users ability to change the Text property of the
node
once the userform initializes? For example belwo the text property is
"Child
11". Once the Tree form pops up, the user can single-click on "Child 11"
and
change the text (like changing file name when single-clicking in folder
tree
in Windows). I don't want the user to have this option.

Set nodX = .Add("C1", tvwChild, "C11", "Child 11")

Thanks

EM

Nick, when I go to the Object Browswer and look under TreeView it appears
under MSComctLib. It appears to have a property called LabelEdit. However,
I cannot seem to access this within my code. It does not pop up as an option
after I type:

TreeView1.Nodes.nodX.

Why would it appear in the Object Browswer but not be available? Does it
have anything to do with the fact that it shows up under MSComctLib?

Thanks
EM


"NickHK" wrote:

The .LabelEdit property ?

NickHK

"ExcelMonkey" wrote in message
...
I am looking for a good resource for the TreeView Control in VBA. Can
anyone
recommend one? In the mean time I have a question.

1) How do disable the users ability to change the Text property of the
node
once the userform initializes? For example belwo the text property is
"Child
11". Once the Tree form pops up, the user can single-click on "Child 11"
and
change the text (like changing file name when single-clicking in folder
tree
in Windows). I don't want the user to have this option.

Set nodX = .Add("C1", tvwChild, "C11", "Child 11")

Thanks

EM