blocks|key|2580781|text|您有几个选项。首先，当TreeView+UserForm显示第二个UserForm时，您需要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2580782|2580783|保存所选节点的ID+(使用窗体级或模块级变量)。然后，您需要编写一个方法来在返回到表单时选择节点。IIRC，您需要为每个节点元素都有一个唯一的“键”或ID，然后对从TreeView.FindNode返回的节点使用TreeView.Select。--或--|ordered-list-item|2580784|隐藏TreeView+UserForm而不是关闭它(Me.Hide)。当第二个UserForm关闭(或按下OK/Cancel+)时，再次显示TreeView+UserForm+(TreeViewForm.Show).|2580785|2580786|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|L|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|M|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|N|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|J|$]]

You have several options. First, when the TreeView UserForm displays the second UserForm, you either need to:

<ol>
<li>Save the ID of the selected node (use a form-level or module-level variable). Then you need to write a method to select the node upon return to the form. IIRC, you need to have a unique 'Key' or ID for each node element and then use TreeView.Select for the node returned from TreeView.FindNode. -- or --</li>
<li>Hide the TreeView UserForm instead of closing it (Me.Hide). When the second UserForm is closed (or OK/Cancel pressed), then show the TreeView UserForm again (TreeViewForm.Show).</li>
</ol>

blocks|key|1911228|text|我知道这是一个古老的问题，但我自己已经很难找到一个像样的答案了，所以我们开始吧。索引或键并不总是可用的。在create上，我将节点的完整路径放在node.tag中。双击I+recall+the+tag+value，稍后在treeview节点集合中搜索该标记。太多了？效率不高？也许吧，但它的作品每次都很有魅力，我可以根据treeview的用途在标签中使用我自己的标识符。查找代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1911229|Sub+MyTreeview_FindNode(strKey+As+String)
Dim+myNode+As+Node

+++For+Each+myNode+In+Me.Treeview.Nodes
+++++++If+myNode.Tag+=+strKey+Then
++++++++++myNode.Selected+=+True
++++++++++myNode.EnsureVisible
++++++++++End+If
+++++++Next
End+Sub+|code-block|syntax|javascript|1911230|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I know this is an old question but i had trouble enough finding a decent answer myself so here we go. Index or Key's are not always available. On create I place the fullpath of the node in the node.tag. On double-click I recall the tag value, later on I search the treeview node collection for the tag. To much? not efficient? maybe but its works likes a charm every time and i can use my own identifiers in the tag based on the purpose of the treeview. The find code:

<pre><code>Sub MyTreeview_FindNode(strKey As String)
Dim myNode As Node

 For Each myNode In Me.Treeview.Nodes
 If myNode.Tag = strKey Then
 myNode.Selected = True
 myNode.EnsureVisible
 End If
 Next
End Sub 
</code></pre>

blocks|key|2580830|text|试试这个:+objTreeview.Object.Nodes(KEY_NAME).Selected=TRUE|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2580831|其中，KEY_NAME是用于创建节点的键(字符串|2580832|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Try this:
objTreeview.Object.Nodes(KEY_NAME).Selected=TRUE

Where KEY_NAME is the key (string) that you used to create the node

blocks|key|4695327|text|在我的Excel作品中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4695328|TreeView1.Nodes(key).Selected+=+True|code-block|syntax|javascript|4695329|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my Excel works:

<pre><code>TreeView1.Nodes(key).Selected = True
</code></pre>

blocks|key|2580859|text|Set+xTree+=+Me!tv_bom.Object
++++++++
xTree.Nodes.Item(Index).Selected+=+True|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2580860|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Set xTree = Me!tv_bom.Object
 
xTree.Nodes.Item(Index).Selected = True
</code></pre>

I have a <code>TreeView</code> within a <code>UserForm</code> in Excel.
When a Node is selected from the <code>TreeView</code>, a <code>ListBox</code> is populated with data. 
When an item in the <code>ListBox</code> is double-clicked, a separate <code>UserForm</code> is shown which allows the user do to stuff. 
Once the user returns back to the <code>TreeView UserForm</code>, I want the <code>Node</code> that was selected previously to be highlighted.

The problem is that the <code>UserForm</code> basically resets itself, and I can't figure out how to select a <code>Node</code> with VBA.

I'm at the point where I'm debating on whether or not I can just manually fire a <code>NodeClick</code> event, as everything else I've tried has failed.

Any tips?

Select a Node in a TreeView with VBA

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在Excel的UserForm中有一个TreeView。从TreeView中选择节点时，将使用数据填充ListBox。当双击ListBox中的项目时，将显示一个单独的UserForm，允许用户执行以下操作。一旦用户返回到TreeView UserForm，我希望突出显示先前选择的Node。​问题是UserForm基本...

问使用VBA在TreeView中选择节点
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用VBA在TreeView中选择节点EN