VB Script using Content Control

gmayor · #1 01-13-2022, 10:51 PM

The code references are to lower case so

Code:

Case Is = "ComSystem"

is never going to be true

Use instead

Code:

Case Is = "comsystem"

Similarly

Code:

If InStr(1, LCase(ContentControl.Range.Text), "test") > 0 Then

There doesn't appear to be a content control titled "BVW" in the document?

gsfousteris · #2 01-14-2022, 01:02 AM

Quote:

Originally Posted by gmayor

The code references are to lower case so

Code:

Case Is = "ComSystem"

is never going to be true

Use instead

Code:

Case Is = "comsystem"

Similarly

Code:

If InStr(1, LCase(ContentControl.Range.Text), "test") > 0 Then

There doesn't appear to be a content control titled "BVW" in the document?

Yeeeees! You really rock and thanks for your valuable assistance. It worked perfectly.

One last question, as the "comsystem" value comes from an automated script and there is no manual intervention to word document, i see that unless i press anywhere in the doc, content control checkboxes are not updated.
Is there any suggestion, to be updated while "Save as" or "Export" are automatically hitted?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Value of a Content Control based on the value of another content Control	jsc_msoffice	Word VBA	2	05-21-2021 09:51 PM
Content Control Dropdowns - How to duplicate the content control and allow a second choice	ashleyf	Word VBA	2	03-19-2020 09:11 AM
Content Control content deleted when re-uploading to SharePoint	Peterson	Word	5	06-27-2018 08:13 PM
Clicking the selected Content Control checkbox returns wrong control in vba event	DougsGraphics	Word VBA	2	06-24-2015 07:31 AM
Deleting a table from a content control -- preserving the content control	BrainSlugs83	Word Tables	8	11-14-2013 03:06 AM