TreeView Questions
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 |
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 |
TreeView Questions
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 |
TreeView Questions
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 |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com