第1个回答 2018-11-27
Private n As Integer
Private Sub CommandButton1_Click()
n = n + 1
If Sheets("Sheet1").Cells(n + 1, 1) <> "" Then
Sheets("Sheet1").Cells(1, 5) = Sheets("Sheet1").Cells(n + 1, 1)
Sheets("Sheet1").Cells(1, 6) = Sheets("Sheet1").Cells(n + 1, 2)
Sheets("Sheet1").Cells(1, 7) = Sheets("Sheet1").Cells(n + 1, 3)
Else
CommandButton1.Enabled = False
End If
End Sub
第3个回答 2018-11-27
自己设定一个单元格记录按的次数,假定为z1单元格。代码如下
sub test()
dim cS as integer
if range("z1")="" then
range("z1")=1
else
range("z1").value=range("z1").value+1
endif
cs=range("z1").value
cells(1,5)=cells(cs,1).value
cells(1,6)=cells(cs,2).value
cells(1,7)=cells(cs,3).value
end sub本回答被提问者采纳