1 Attachment(s)
Excel to Word - Formatted with Titles, Heading 1, via ActiveX Check Box
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.
Attachment 25431
