Real-time MS Word table formatting based on checkbox

Question

Hello

I'm trying to find a way to do real-time formatting on a table when a checkbox is selected. I'm trying to make an interactive checklist. As the user completes a step, they will check the box. Excel would probably be easier but this will be located in a Operator's Manual that will be a Word doc. Please advise

Update: By "real time formatting", I want the row to highlight automatically when the checkbox is clicked. 

Answer 1

If you are using ContentControl Checkboxes and you assign the title Check to each of them, if you have the following code in the ThisDocument object, the rows will be shaded as you want

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)

If ContentControl.Title = "Check" Then

If ContentControl.Checked = True Then

    ContentControl.Range.Rows(1).Shading.BackgroundPatternColor = wdColorYellow

Else

    ContentControl.Range.Rows(1).Shading.BackgroundPatternColor = wdColorWhite

End If

End If

End Sub

Answer 2

What do you mean by "real-time formatting"?

Answer 3

Please expand on the formatting you want to do.

Take a look at this reply to a similar question:

https://stackoverflow.com/questions/45711329/conditional-formatting-in-microsoft-word-2016-table-cells

Point 4 means you create your table in Excel, with conditional formatting. You copy the area in Excel and Paste special it into Word as an excel object. You can enter data in the "excel" table embedded in Word, Excel will handle the conditional formatting.

Answer 4

What do you mean by "real-time formatting"?

When the checkbox is clicked, it instantly colors the cell.

I was able to find macros that you run that will color the cells checked but you have to run it after the fact

Answer 5

Please expand on the formatting you want to do.

Take a look at this reply to a similar question:

https://stackoverflow.com/questions/45711329/conditional-formatting-in-microsoft-word-2016-table-cells

Point 4 means you create your table in Excel, with conditional formatting. You copy the area in Excel and Paste special it into Word as an excel object. You can enter data in the "excel" table embedded in Word, Excel will handle the conditional formatting.

I just tested Point 4. It copies the table over but with odd formatting. Also, the conditional formatting does not carry over into word. The person is saying to do all the "checking" in excel and copying the final results into Word.