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

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.

Calculate it with

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

--
HTH

Bob Phillips

"Maddoktor" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>