View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default TreeView Questions

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