Auto increment next cell when adding multiple entries from userform

Hi,

This is driving me nuts, please help!!

I have 5 textboxes on a userform, this is a stock updater from. If my txtQty textbox reads 5, it does add the details 5 times to a spreadsheet called "Log Information".

Problem is I need it to auto increment the serial number colomn based on the quantity textbox. Thus, if I have serial number 100 inserted in my userform and the quantity reads 5 I want all the information to be added to the spreadsheet but the serial number colomn must auto increment each row to the next value. i.e:

Name Serial Number bla bla blaaa
Chris 100
Chris 101
Chris 102
Chris 103....etc.

This is the code I have adding the data to the spreadsheet.

Please Login or Register  to view this content.

****Please help****

hi there,

try sort of that:

Please Login or Register  to view this content.

Hi waterserv,

Thank you very much, wirks like a charm. One thing is that if the serial number is alphanumeric it does not update the worksheet, meaning all data are filled in except the serial number colomn...any ideas?

Thanks again for your reply.

Please Login or Register  to view this content.

Hi watersev,

I have added that code as follows:

Please Login or Register  to view this content.

This has stopped the auto increment and the serial number stays the same.

Any ideas?

Hi watersev,

Please excuse if I am asking stupid questions or making stupid mistakes.

I have changed all the lines as follows:

Please Login or Register  to view this content.

this is still not incrementing the serial number.

Am a doing something stupid here?

Still trying to figure all thia out.

Hi watersev,

Please excuse if I am asking stupid questions or making stupid mistakes.

I have changed all the lines as follows:

Please Login or Register  to view this content.

this is still not incrementing the serial number.

Am a doing something stupid here?

Still trying to figure all thia out.

post a workbook

Project attached

Thanks again for your help with this.

if I get everything right the originally posted code should be:

Please Login or Register  to view this content.

As a result new records are added in Information Log sheet. Column B is incremented if numeric, if it's not - same value in the whole range.

Aside from the absence of check for valid date and quantity positive integer entered, I do not see any problem on incrementing

Hi watersev,

Sorry for the delay in response.

Is there any way of auto incrementing a number even though it is alphanumeric? Almost all my serial numbers end with 3 digits at the end, i.e A345A123 or 145A23C232.

Please Login or Register  to view this content.

Hi watersev,

Thank you for the time you have taken to help me with this, I really do appreciate it.

The above code works perfect for my alphanumeric numbers but it does not increment only numeric numbers now?

But please do not worry about it, I will look at some of the previous code you have sent me and figure it out.

Thanks again and enjoy your Christmas.

please change this:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi watersev,

This did sort the problem, thank again.