|
发表于 2012-12-15 02:14
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton1_Click()
- Dim jsxm$
- With Me.ListView1
- jsxm = .SelectedItem.Text
- .ListItems.Remove .SelectedItem.Index
- End With
- With Worksheets("3")
- If Not .Range("a:a").Find(jsxm, , LookIn:=xlValues, lookat:=xlWhole) Is Nothing Then
- .Range("a:a").Find(jsxm, , LookIn:=xlValues, lookat:=xlWhole).EntireRow.Delete
- MsgBox "删除成功"
- End If
- End With
- End Sub
复制代码 |
|