Userform vlookup with the ability to save or select values

Thank you very much for the quick reply. That is almost exactly what I want but is it possible for the amended value in TextBox1 to be saved with a click of a button i.e. the cell value to be actually changed?