You can also use buttons, menu items, shortcut keys to trigger the userform. Based on your sample data I would approach things differently. I would call up long text to the userform and use Find/Replace to change all identical items. Is your sample typical of your real data?

The data already exsists in the spreadsheet. They are cutting and pasting the data from QuatroPro
See the text is already in a spreadsheet and then the person has to shorten it before sending to another app
These statements are confusing me as to the process involved.