I have set up a userform which lets a user fill in a number of fields
then enters the data on a sheet.

I want to use the Row that the data will be saved on as the unique
identifier for the record.

What is the best way to report information in the field that says....

"this is record number XXXX" = Total saved rows + 1

I also want to be able to review records and pull cell data from
specific cells on the sheet into a text box.

Thanks for any help
David