Creating a letter in Word, with text pulled from an Excel document based on selections in a userform

TMAL · #6 12-15-2017, 09:26 AM

Follow-up question; this may not be related.

After working on the above template I went back to working on another project that I had completed about a month ago to put in some minor updates. It's a word document with about 100 questions, with radio buttons and checkboxes used for the various responses. I have VB code so that when a button is selected, the associated text changes to green (for positive responses) or red (for negative responses); however, when I opened the document today, none of those colour changes appear to be working. There don't appear to be any issues with the code itself, but I can't figure out for the life of me why it's not working.

Most of the code would look something like this:

Code:

 
Private Sub CheckBox223_Click()
    If CheckBox223.Value = vbChecked Then
        CheckBox223.ForeColor = vbBlack
    Else:
        CheckBox223.ForeColor = RGB(0, 128, 0)
    End If
End Sub

or

Code:

 
Private Sub OptionButton61_Change()
 With OptionButton61
 If .Value Then
 .ForeColor = RGB(0, 128, 0)
 Else
 .ForeColor = vbWindowText 
 End If
 End With
 End Sub

I'm stumped. I spoke with a few of my colleagues that I had designed the document for, and it appears that the colour changes are still working on their end. Hope I'm not missing something super obvious here.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change colours in different tables based on dropdown selections	kevinbradley57	Word VBA	10	08-09-2017 03:54 PM
Excel to Word data import based on UserForm entry	jhancock1994	Word VBA	8	05-16-2017 04:41 PM
Help with Hide/Display of sections of document based on Drop Down selections	turnquistcm	Word	2	05-03-2017 07:05 PM
Need help creating a Word document that is populated based on certain selected values	alidaanish	Word	1	01-10-2014 10:44 PM
Creating a shared template with selections	gmsp26	Word	1	04-14-2011 05:18 PM