Private Sub CommandButton1_Click() Dim a As Integer a = Range("a1040000").End(xlUp).Row + 1 Sheets("sheet1").Range("a" & a) = TextBox1.Text Sheets("sheet1").Range("b" & a) = TextBox2.Text Sheets("sheet1").Range("c" & a) = TextBox3.Text Sheets("sheet1").Range("d" & a) = TextBox4.Text CommandButton2.SetFocus End Sub
PrivateSub CommandButton1_Click() Dim a AsInteger a = Range("a1040000").End(xlUp).Row + 1 Sheets("sheet1").Range("a" & a) = TextBox1.Text Sheets("sheet1").Range("b" & a) = TextBox2.Text Sheets("sheet1").Range("c" & a) = TextBox3.Text Sheets("sheet1").Range("d" & a) = TextBox4.Text CommandButton2.SetFocus '加上此句代码 EndSub