The macro will replace the word of phrase in column 1 with the word or phrase in column 2, formatted as it is formatted in column 2.
With regard to the userform, you didn't make a mistake. Add the missing line to the code module. See
https://www.gmayor.com/Images_2011/Userfo3.jpg