Hi there,
Does anyone know the code to delete a line in excel I've just created using my userform.
The code for inserting user input is:
Worksheets("Records").Range("Start").End(xlDown).Select
With Selection
RefNumInt = .Offset(0, 0) + 1
.Offset(1, 0) = RefNumInt
.Offset(1, 1) = EmployeeNameBox
.Offset(1, 2) = DTPicker1
.Offset(1, 3) = HoursDepositBox
End With
I just need help with deleting the line if the input has been incorrect.
Any help would be much appreciated. Thanks
Does anyone know the code to delete a line in excel I've just created using my userform.
The code for inserting user input is:
Worksheets("Records").Range("Start").End(xlDown).Select
With Selection
RefNumInt = .Offset(0, 0) + 1
.Offset(1, 0) = RefNumInt
.Offset(1, 1) = EmployeeNameBox
.Offset(1, 2) = DTPicker1
.Offset(1, 3) = HoursDepositBox
End With
I just need help with deleting the line if the input has been incorrect.
Any help would be much appreciated. Thanks