I have an UserForm which staff uses to initiate entries on a
WorkSheet. I now need to activate that same UserForm and populate the
fields with data from a selected row, so staff can edit enties.

If I click on a Cell in a row of data, how do I:

1. Capture the row number for use in the formula - say R is Rows
UserForm.ADate.Value = Worksheets("Contacts").Cells(R,2).Value

2. Load the UserForm with that data from the selected Row.

That's enough for now. Appreciate any directions.