Private Sub Listbox2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Dim r2
ActiveCell.Value = ListBox2.Value
Me.ListBox2.Clear
Me.TextBox2 = ""
Me.ListBox2.Visible = False
Me.TextBox2.Visible = False
If j > 0 Then Set r2 = Sheet5.Columns(j).Find(ActiveCell.Value, , , xlWhole)
End Sub要顺畅使用,还得改。上面红色的加上后将就可用: