- 帖子
- 2843
- 主題
- 10
- 精華
- 0
- 積分
- 2899
- 點名
- 0
- 作業系統
- 〔略〕
- 軟體版本
- 〔略〕
- 閱讀權限
- 100
- 性別
- 男
- 來自
- 〔略〕
- 註冊時間
- 2013-5-13
- 最後登錄
- 2025-6-9
|
2#
發表於 2015-9-8 23:00
| 只看該作者
- Private Sub CommandButton1_Click()
- With Sheets("Sheet1")
- .[H1].Value = Label2.Caption
- .[H2].Value = Label3.Caption
- End With
- End Sub
-
- Private Sub ListBox1_Change()
- Label2.Caption = ListBox1.Column(0)
- Label3.Caption = ListBox1.Column(1)
- End Sub
-
- Private Sub TextBox1_Change()
- Dim i, Arr, xD, N&
- If TextBox1 = "" Then GoTo 101
- Arr = Sheet1.UsedRange.Columns("A:B").Cells
- Set xD = CreateObject("Scripting.Dictionary")
- For i = 2 To UBound(Arr)
- If InStr(Arr(i, 2), TextBox1) Then N = N + 1: xD(N) = Array(Arr(i, 1), Arr(i, 2))
- Next i
- If N = 0 Then GoTo 101
- ListBox1.List = Application.Transpose(Application.Transpose(xD.items))
- ListBox1.Visible = True
- Exit Sub
- 101:
- Label2.Caption = "": Label3.Caption = "": ListBox1.Visible = False
- End Sub
-
- Private Sub UserForm_Initialize()
- ListBox1.Visible = False
- End Sub
複製代碼 附件下載:
明細查詢v01.rar (53.28 KB)
|
|