I did that a while ago using a userform with textboxes. Each textbox
was linked to one of the different columns on the worksheet. I used a
macro to search for a record then set that cell  to active and used :



Range("E" & ActiveCell.row)=commentstextbox.text



I used similar lines of code to populate the textboxes on the userform
and then I was able to modify them as I desired. Afterwords I used a
command button to use another macro to update that record to what was in
the userform. I would give more help with specific code but the form
was very large and had a lot of code for a lot of other things in there
as well.