The TreeView control reports its current node–the selected node–only in its NodeClick event’s Node parameter. If you need to access the Node’s properties–such as Key or Text–outside this event, you need to declare a Node variable with scope appropriate to your intended usage. To share within a form, include a variable declaration in the Declarations section:
Option ExplicitPrivate CurrentNode As nodeSet your variable–in this illustration, CurrentNode–to the node passed in the event:
Private Sub tvwDB_NodeClick(ByVal node As node)Set CurrentNode = nodeYou can now access CurrentNode’s properties from anywhere on the form:
Debug.Print CurrentNode.KeyDebug.Print CurrentNode.Text
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
