Private Sub UserForm_Initialize()
刷新
End Sub
Private Sub 删除指定行_Click()
m = Sheet1.Range("a65536").End(xlUp).Row
For I = ListBox1.ListCount - 1 To 0 Step -1
If ListBox1.Selected(I) = True Then Sheet1.Rows(I + 1).Delete '选定时则对应行删除
Next I
刷新
End Sub
Sub 刷新()
Dim sz() As Integer
m = Sheet1.Range("a65536").End(xlUp).Row
ReDim sz(1 To m)
For I = 1 To m
sz(I) = Sheet1.Cells(I, 1)
Next I
ListBox1.Clear
ListBox1.List = sz
End Sub
Private Sub UserForm_Initialize()
刷新
End Sub
Private Sub 删除指定行_Click()
m = Sheet1.Range("a65536").End(xlUp).Row
For I = ListBox1.ListCount - 1 To 0 Step -1
If ListBox1.Selected(I) = True Then Sheet1.Rows(I + 1).Delete '选定时则对应行删除
Next I
刷新
End Sub
Sub 刷新()
Dim sz() As Integer
m = Sheet1.Range("a65536").End(xlUp).Row
ReDim sz(1 To m)
For I = 1 To m
sz(I) = Sheet1.Cells(I, 1)
Next I
ListBox1.Clear
ListBox1.List = sz
End Sub