Automatically increment a unique number when filling in a userform in excel

[Maddoktor]

Hi all,

I have created a userform in Excel to enter data into a worksheet. In Column
A, I have a unique number beginning at number 1 and incrementing everytime
data is entered into Column B, C, etc. I would like to have a unique field
in the userform that will increment the number in Column A (with no input
from the user) and for the user to enter the remaining data into the
userform that will fill in Columns B,C, etc for the row as the unique
incrementing number.

Is this possible?

Thanks in advance for helping.

 

[Bob Phillips]

Calculate it with

iId = Cells(Rows.Count,"A").End(xlUp).Value + 1