Auto product code generation with user form

[Ramesh h&m]

Hi,

I have a user form in excel.
User-form created to add product details in the excel sheet.
The product details will be
A2. S no
B2. Brand name (column
C2. product name
D2. Description
E2. size
F2. color
G2. pages
H2. unit
I2. Product code

i need to generate a product code for every products added in this sheet.

Pls find the attached sample template and advise if more details you need..

[AliGW]

See this thread from a few moments ago: https://www.excelforum.com/excel-gen...er-column.html

EDIT: Apologies - I did not see the user form requirement. This needs to be in the VBA section - I'll move the thread for you.

[Special-K]

in I3
=IF(B3="","","A"&TEXT(ROW()-2,"0000"))
and copy down the column

[Shareez Saleem]

If(c3<>"",concatenate("a",text(rows($a$1:a1),"0000"),""))

[Ramesh h&m]

Hi
Alig tks...
Special-K... wow super code and works perfectly tks..
Shareez.. tks

[AliGW]

OK, so the code does not have to be generated on the user form?

[Arkadi]

I helped the OP with the code for the useform that adds a product, in there is a VBA solution already as well? Granted, part of much more code, but this line in that post generates the "next" code based on the last row with a code in it:

.Range("I" & lr).Value = Left(.Range("I" & lr - 1).Value, 1) & Format(Val(Mid(.Range("I" & lr - 1).Value, 2)) + 1, "0000")

@Ramesh, did the code I provided in that previous thread not work well?

[Ramesh h&m]

I helped the OP with the code for the useform that adds a product, in there is a VBA solution already as well? Granted, part of much more code, but this line in that post generates the "next" code based on the last row with a code in it:

.Range("I" & lr).Value = Left(.Range("I" & lr - 1).Value, 1) & Format(Val(Mid(.Range("I" & lr - 1).Value, 2)) + 1, "0000")

@Ramesh, did the code I provided in that previous thread not work well?

Hi Arkadi,

Don't mistake me..

After replied you on my previous thread, i found this auto generation code is not working. The particular code turned in to red.
I am sure that, not missed anything in the code but i don't know why its not working..

Then, i think it will be possible in excel functions. Hence i requested excel formula in a new thread to cleared it.

@Aligw.. I am happy to get help from Arkadi for do my user-form project successful.

As i am new to the VBA, if i get any error in the codes, I don't like to give burden for the experts, to ask about the errors.

Hence i think simply to solve it by excel formulas.