Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 1446|回复: 0

跪求帮助!

[复制链接]
发表于 2012-12-22 11:56 | 显示全部楼层 |阅读模式

运行以下代码报错:
提示:未发现元素
Private Sub 二级类别_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
n = 1‘全局变量
If KeyCode = 13 Then
  Unload Me
  类别选择窗口.Show
  类别选择窗口.Caption = "合同类别"
End If
End Sub

“类别选择窗口”下的代码如下

Private Sub UserForm_Initialize()
Dim Nodx As Node
Dim x
x = "请从下表中选择“" & Me.Caption & "”"
TreeView1.ImageList = ImageList1
Set Nodx = TreeView1.Nodes.Add(, , "H", x)
For x = 2 To Sheet1.Range("B65536").End(xlUp).Row
   c1 = Sheets(n).Cells(x, 2)
   c2 = Sheets(n).Cells(x, 3)
   If Len(c1) = 1 Then
     Set Nodx = TreeView1.Nodes.Add("H", tvwChild, c1, c2, 1)
   ElseIf Len(c2) = 3 Then
     Set Nodx = TreeView1.Nodes.Add(Left(c2, 1), tvwChild, c1, c2, 2)
   ElseIf Len(c1) = 5 Then
     Set Nodx = TreeView1.Nodes.Add(Left(c2, 3), tvwChild, c1, c2, 3)
   ElseIf Len(c1) = 7 Then
     Set Nodx = TreeView1.Nodes.Add(Left(c2, 5), tvwChild, c1, c2, 4)
   End If
Next
End Sub
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-4-28 01:00 , Processed in 0.437668 second(s), 12 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表