Access the TreeView Control’s Current Node Properties

Access the TreeView Control’s Current Node Properties

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 node

Set your variable–in this illustration, CurrentNode–to the node passed in the event:

 Private Sub tvwDB_NodeClick(ByVal node As node)Set CurrentNode = node

You can now access CurrentNode’s properties from anywhere on the form:

 Debug.Print CurrentNode.KeyDebug.Print CurrentNode.Text
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular