This might be a bit confusing so bear with me. I am aware that you can use VBA to transfer excel information into a Word Document, but looking for more advanced formatting.
I am looking to do the following:

  • When someone selects an ActiveX Checkbox in my spreadsheet for "E-Commerce Overview," I would like the content shown in the image below to populate in the Word Template I specify.
  • I would need to be certain that formatting in Word will relay "E-Commerce Overview" as a Title, "Value Proposition" as Heading 1, and that the [CUSTOMER NAME] pulls from the excel sheet and populates into the Word Doc.
  • This formatting is important because we are using a table of contents at the start of the Word Document.



I am not necessarily asking for someone to write the code for me, but I just want to know this is possible before diving into the rabbit hole.

MREXCEL.jpg