Update a row in excel using vba

I need to create excel macro.My requirement is to select a row and click on edit button it should take to new pop up window displaying all selected record 's information. When i change and click on update button, it should save those changes in sheet. Thanks for your help.