Userform

[MrSudsy224]

I have a userform set up for a clerk to enter ticket number which are generally sequencial, but not always. One of the options for the box is "Next" and if that is the choice, I would like the number entered into the cell to be the next number in the sequence. I tried this, but no luck:

TargetRow = Sheets("Engine").Range("B3").Value

If Ticket_Number = "Next" Then
Sheets("Data").Range("Data_Start").Offset(TargetRow, -1).Value = 1
Else
Sheets("Data").Range("Data_Start").Offset(TargetRow, 0).Value = Ticket_Number
End If

Any ideas?

[Logit]

.
I'm guessing the cell containing the ticket number is B3.

If that is accurate, the macro would be :

Please Login or Register  to view this content.