TreeView Questions

[ExcelMonkey]

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

 

[NickHK]

The .LabelEdit property ?

NickHK

 

[JimAnAmateur]

perhaps
..SingleSel = True

br Jim

 

[ExcelMonkey]

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]

You see that LabelEdit is a member of TreeView. So it applies the whole
control not a specific node:
TreeView1.labelEdit=tvwAutomatic/tvwManual

NickHK