|
是这样吗,请看附件。
Sub CommandButton1_Click()
For i = 1 To 7
If [i12].Offset(-i, 0) = "" Then
[i12].Offset(-i, 0) = [a2]
[i12].Offset(-i, 1) = [d2]
[i12].Offset(-i, 0).Resize(1, 2).Font.ColorIndex = 43
Exit Sub
End If
Next
[i5:j11] = ""
End Sub
Sub CommandButton2_Click()
For i = 1 To 7
If [i12].Offset(-i, 0) = "" Then
[i12].Offset(-i, 0) = [a3]
[i12].Offset(-i, 1) = [d3]
[i12].Offset(-i, 0).Resize(1, 2).Font.ColorIndex = 3
Exit Sub
End If
Next
[i5:j11] = ""
End Sub
Sub CommandButton3_Click()
For i = 1 To 7
If [i12].Offset(-i, 0) = "" Then
[i12].Offset(-i, 0) = [a4]
[i12].Offset(-i, 1) = [d4]
[i12].Offset(-i, 0).Resize(1, 2).Font.ColorIndex = 41
Exit Sub
End If
Next
[i5:j11] = ""
End Sub |
|