UserForm autonumber

[adeleex]

Hi all,
I have a UserForm which submits data to another worksheet; it also specifies an autonumber for each new record, however I have some code which finds the fist empty cell and the two don’t work together well.

The code makes a number appear in cell A1 but places the UserForm data underneath it in A2

Is it possible to amend the code allow the auto number to appear in A1 and UserForm data to appear in B1

Here is the code:

Please Login or Register  to view this content.

Many thanks,

Adele

[mohd9876]

just remove the offset from the lRow line:

Please Login or Register  to view this content.

[royUK]

Your code will come unstuck if the data is sorted differently

Please Login or Register  to view this content.

[adeleex]

mohd9876, I removed the offset from the lRow line and now when I enter data it just removes the auto number completely and puts the data into cell A1?

royUK I tried this instead and got a host of errors! (my coding skill are terrible tho!!)

[snb]

this suffices:

Please Login or Register  to view this content.

[adeleex]

snb, works great!!! xx