|
本帖最后由 fls996 于 2013-10-19 16:32 编辑
Private Sub CommandButton1_Click()
Dim i As Integer, j As Integer, k As Integer, h As Integer
For i = 1 To 4
Sheets("sheet1").Range("A65536").End(xlUp).Offset(1, 0) = Controls("textbox" & i).Text
Sheets("sheet1").Range("A65536").End(xlUp).Offset(0, 1) = Controls("textbox" & i + 4).Text
Sheets("sheet1").Range("A65536").End(xlUp).Offset(0, 2) = Controls("textbox" & i + 8).Text
Sheets("sheet1").Range("A65536").End(xlUp).Offset(0, 3) = Controls("textbox" & i + 12).Text
Next i
End Sub
- For i = 1 To 4
- With Sheets("sheet1").Range("a65536").End(xlUp)
- For j = 1 To 4
- .Offset(1, j - 1) = Controls("textbox" & i + j * 4 - 4).Text
- Next
- End With
- Next
复制代码
|
|