Snasui Excel Forum

Posted: **Tue Sep 29, 2020 5:38 pm**

Hi Dear
I need your help how to increment invoice number thru textbox with prefix
Here is my code:

Private Sub UserForm_Initialize()
Dim irow As Long
Dim ws As Worksheet
Set ws = Worksheets("Accounts Receivable")
'find last row in database
irow = ws.Cells(Rows.Count, 1).End(xlUp).Row
TextBox1.Value = "INV-"& ws.Cells(irow, 1) + 1
End Sub

Best Regards

Posted: **Tue Sep 29, 2020 10:55 pm**

I can't find any error of your code.

Posted: **Tue Sep 29, 2020 11:26 pm**

I want it to show INV-001,INV-002 etc

Posted: **Wed Sep 30, 2020 8:39 am**

Please attach the example file and point to the problem.

Snasui Excel Forum

how to increment invoice num with prefix

how to increment invoice num with prefix

Re: how to increment invoice num with prefix

Re: how to increment invoice num with prefix

Re: how to increment invoice num with prefix