|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Option Explicit
- Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
- ActiveCell.Value = Me.ListBox1.Value
- End Sub
- Private Sub Worksheet_SelectionChange(ByVal T As Range)
- If T.Count > 1 Then Exit Sub
- If T.Column = 2 Then
- Dim d As Object, i As Integer, arr As Variant
- Dim sh As Worksheet
- Set d = CreateObject("Scripting.Dictionary")
- For Each sh In Sheets
- If sh.Name <> ActiveSheet.Name Then
- arr = sh.Range("b6:b" & sh.[b65536].End(3).Row).Value
- For i = 1 To UBound(arr)
- If Len(arr(i, 1)) Then d(arr(i, 1)) = ""
- Next
- End If
- Next
- If d.Count > 0 Then
- With Me.ListBox1
- .Width = 400
- .Height = 400
- .Top = T.Top
- .Left = T(1, 2).Left
- .List = Application.Transpose(d.keys)
- .Visible = True
- End With
- End If
- Set d = Nothing
- Else
- Me.ListBox1.Visible = False
- End If
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|