Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Checkbox in Form / Table

0 views
Skip to first unread message

Andy Roberts

unread,
Nov 10, 2009, 1:36:19 PM11/10/09
to
I have a checkbox on a protected form within a complicated table in Word.
When I check the box I want it to box Red and Bold (like conditional
formatting in Excel). Is it possible?

Andy


Doug Robbins - Word MVP

unread,
Nov 10, 2009, 8:51:24 PM11/10/09
to
You cannot change the colour of the checkbox itself, but the following code
in a macro run on exit from the checkbox formfield will colour the cell in
which the checkbox is located - Red if it is checked and Green if not.

With ActiveDocument
.Unprotect
With Selection
If .FormFields(1).CheckBox.Value = True Then
.Cells(1).Shading.BackgroundPatternColor = wdColorRed
Else
.Cells(1).Shading.BackgroundPatternColor = wdColorGreen
End If
End With
.Protect wdAllowOnlyFormFields, NoReset
End With


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"Andy Roberts" <an...@blue-bean.co.uk> wrote in message
news:%23EnZzSj...@TK2MSFTNGP06.phx.gbl...

0 new messages