|
发表于 2012-6-27 11:05
|
显示全部楼层
本楼为最佳答案
Private Sub CommandButton1_Click()
r = Sheets("sheet2").Range("a65536").End(xlUp).Row + 1
With ListView1
For i = 1 To .ListItems.Count
If .ListItems(i).Checked Then
Sheets("sheet2").Cells(r, 1).Resize(1, 5) = Sheets("sheet1").Cells(i + 1, 1).Resize(1, 5).Value
.ListItems(i).Checked = False
r = r + 1
End If
Next
End With
UserForm1.Hide
Sheets("sheet2").Select
End Sub
Private Sub OptionButton1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
With ListView1
For i = 1 To .ListItems.Count
.ListItems(i).Checked = True
Next
End With
End Sub
Private Sub OptionButton2_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
With ListView1
For i = 1 To .ListItems.Count
.ListItems(i).Checked = Not .ListItems(i).Checked
Next
End With
End Sub
|
评分
-
查看全部评分
|