insert auto serial number in user form

[AhmedMatboly]

Private Sub UserForm_Initialize()
Dim NewSerno As Long

NewSerno = [Sheet].Cells(Rows.Count, "A").End(xlUp).Value + 1
[Sheet].Cells(Rows.Count, "A").End(xlUp.Offset(1) = NewSerno
Text1.Value = NewSerno
End Sub

Thanks sir for your help i really appreciate it