Excel to Word using ActiveX Check boxes. With formatted text.

**noslenwerd** · 11-22-2019, 11:09 AM

Please see attached image.

I showed a simplified version of what my sheet will be doing. But I will have nearly 100 check boxes, with 100 different topics.

My issue is I want to ONLY show content on the Word Doc when the associated checkbox is "true" on the excel sheet. It must also have 'Heading 1' formatting, and hyperlinks. What is my best path forward?

Have all the content prepopulated in the Word Doc, and have a macro that deletes content that isn't checked in the excel doc?
Start with a blank Word Doc, and populate only content that is checked in Excel.

Thanks so much for your time!

excel-question.jpg

**jeffreybrown** · 11-22-2019, 06:35 PM

Administrative Note:

Welcome to the forum.

We would love to help you with your query; however, it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly.

Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

https://www.mrexcel.com/board/thread...k-box.1115355/

http://www.vbaexpress.com/forum/show...596#post396596

**macropod** · 11-23-2019, 04:30 PM

Those aren't the only cross-post sites, either. There's at least two others...

Excel to Word using ActiveX Check boxes. With formatted text.

LinkBack

Thread Tools

Rate This Thread

Display

Excel to Word using ActiveX Check boxes. With formatted text.

Re: Excel to Word using ActiveX Check boxes. With formatted text.

Re: Excel to Word using ActiveX Check boxes. With formatted text.

Thread Information

Users Browsing this Thread

Similar Threads

Mail Merge From Excel to Word using check boxes.

Insert additional check boxes (ActiveX) to worksheet if more rows of data are added

[SOLVED] Auto insert ActiveX check boxes

[SOLVED] Aggregate Batch Data from many word docs into an Excel (i.e.Check Boxes, Text Form Fields)

I need a code for presence check to check multiple text boxes and combo boxes

excel check boxes moving when excel selected cells pasted in word

How can I protect a worksheet but still use ActiveX check-boxes?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions