Hi macropd, the reason it has to be done in excel first is because I require another team to fill in the variables for me. The spreadsheet itself is used to satisfy all necessary legal requirements we need to adhere to.

So far i've just got a cell off to the far right with the VLOOKUP stuff in it, where the template text will be held.

I was thinking a copy and paste special macro assigned to a button would work to copy the contents of the cell, and paste special (values) into a text box, which will allow the text to then be edited.

I tried to 'record a macro', but all it did was include the actual templated text within the macro, which means even if the variables are changed, the text won't.

After trying to watch some youtube videos and more googling, I've got this so far... I can get the Copy to work correctly, just don't know how to refer to the textbox...
I recorded a new macro and selected the text box, then typed random words into it just so i could try to figure out the code on how to refer to the textbox, but I seem to be stuck.