Hi,

I have a worksheet of data holding information such as names, DOB, gender, address etc. Each row has a unique ref in column A.

My initial requirement was a vbForm and associated routine that on the click of a button would present the information held in the worksheet for a specific record the user wishes to check/edit. This I have managed to successfully achieve via an inputbox that requests the unique ref, the value of which upon entry is then searched for in column A. Once found the corresponding data items for that row are inserted into the form and presented to the user.

What I am struggling with now, however, is how to then arrange for any values within the form that are amended by the user to replace the existing details in the worksheet.

For example, row 10 of the data has the following values:
  • Unique ref (column A) : 152
  • First name (column B): Bob
  • Surname (column C): Jones
  • DOB (column D):
  • Gender (column E): female
  • Postcode (column F): BS1 1AA

This is presented in the userform after 152 is inserted in the input box. What I want is for the user to be able to add the DOB and correct the gender to male using the form, which after clicking Save will automatically apply the changes to cells D10 & E10 of the worksheet.

Is this something someone could give me some guidance on please?

Any questions please let me know, many thanks in anticipation.