Private Sub 尾号文本_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim y1 As Single y1 = Range("A65536").End(xlUp).Row + 1 Cells(y1, 1).Value = UserForm1.Controls("代码文本1") & UserForm1.Controls("年份文本") & UserForm1.Controls("代码文本2") & UserForm1.Controls("尾号文本") & "P" Cancel = True End Sub