Swap word in a sentence with input from a textbox or a drop down

I don't know if I have a solution for you, but it would make it easier to help if you could attach a copy of your file with a detailed explanation of what you want to do referring to specific cells, rows, columns and sheets.

You have attached a picture which I cannot access. Please attach a copy of your file. Click the "Go Advanced" button at the lower right. Then scroll down a bit and click "Manage Attachments".

You could put this in the sheet's code module.
Or you could just use Excel's existing Replace dialog box instead of introducing your own control.

Please Login or Register  to view this content.

What happened when you tried it?

You've mentioned that you have no VBA experience.
The attached uses no VBA, only native Excel that is cross platform from Windows to Mac.

Column A has the list of possible countries. Add to it as you need.
The cell B1 has data validation set so the user can only choose from the list of possible countries.
Column D has the template text, where you type what you want except you enter [country] where you want the country name to be.
Column F has the final result, where the selected country has replaced [country] from the template text.

Note:
1) the use of a dynamic named range to include additions to your list of possible countries.

2) the result column has formulas that need to be copied down to include all of the rows of the template text column.