Private Sub CheckBox1_Click() '全选复选框,新加
Dim f As Boolean, i&
f = CheckBox1.Value
With ListBox1
For i = 0 To .ListCount - 1
.Selected(i) = f
Next
End With
End Sub
Private Sub CommandButton1_Click() '确认删除
Dim rng As Range, i&, m&
With ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
m = m + 1
If m = 1 Then Set rng = Cells(i + 2, 1) Else Set rng = Union(rng, Cells(i + 2, 1))
End If
Next
End With
If m > 0 Then
If MsgBox("你选择了" & m & "个职工,是否删除?", vbInformation + vbYesNo, gsAPP_TITLE) = vbYes Then
rng.EntireRow.Delete
Call UserForm_Initialize
End If
End If
End Sub
Private Sub UserForm_Initialize()
Dim lr&
lr = Range("a65536").End(xlUp).Row
With ListBox1
.RowSource = ""
If lr > 1 Then .List = Range("a2:a" & lr).Value
.MultiSelect = fmMultiSelectMulti
.ListStyle = fmListStyleOption
End With
End Sub
Private Sub CommandButton2_Click() '取消
Unload Me
End Sub