Excel VBA, cannot update table after editing form data

[EKExcel]

Hi All,

I have a VBA form, ViewEditStakeholders, which I use to scroll through existing records I added using a different VBA Form AddNewStakeholders. The forms to add and search the records work fine, but I cannot get the code to update a recorded if the entry in the ViewEditStakeholders form has been changed. I have added the code below and an image of the form. You will see where the records appear on the right after seaching. I want to be able to change these and update the table after clicking the update button. you will notice I have a delete record button also, I have not started coding this yet as I cannot get the records to update so definitely cannot get a row to delete.

Screenshot 2015-11-17 08.53.26.png

Please Login or Register  to view this content.

[EKExcel]

PS - "RngSH" is a defined dynamic named range for the column with the TextSHID Values in column 1