|
发表于 2013-9-3 14:46
|
显示全部楼层
本楼为最佳答案
- Dim arrSource, arrResult
- Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
- With Me.ListBox1
- If .ListIndex > -1 Then
- Sheet1.Range("b6").Value = .List(.ListIndex)
- Else
- MsgBox "列表框无选项"
- End If
- End With
- End Sub
- Private Sub TextBox1_Change()
- arrResult = Filter(arrSource, Me.TextBox1.Value, True, vbBinaryCompare)
- If UBound(arrResult) <> -1 Then
- Me.ListBox1.List = arrResult
- Else
- Me.ListBox1.Clear
- End If
- End Sub
- Private Sub UserForm_Initialize()
- With Sheet1
- arrSource = .Range(.Range("a2"), .Cells(Rows.Count, 1).End(xlUp).Offset(, 1)).Value
- arrSource = WorksheetFunction.Index(arrSource, 0, 1)
- arrSource = WorksheetFunction.Transpose(arrSource)
- Me.ListBox1.List = arrSource
- End With
- End Sub
复制代码 |
|