Update excel based on userform text box update

Hi,

I have a text box which populates values from a range.
The text box is locked by default.
Once user clicks on an edit button, user will be able to change the value in the text box.
And after changing, once user clicks on one Save button, I need the new value to be updated in the excel sheet in the exact position.

Here is the code that I'm using.

Please Login or Register  to view this content.

As mentioned above, when user clicks an Edit button, the textbox teamName will be editable, and user can change values in it.
There is also another Save button. I want the exact position in the excel sheet to be updated when user clicks save button in user form.

Best Regards
Sivakumar

A similar query has been posted in another forum.
http://www.mrexcel.com/forum/excel-q...ml#post3361718