Microsoft Office Forums - View Single Post - Reference a Building block gallery control from another Field and insert text using If logic

gmayor · 07-30-2018, 12:59 AM

As we have no idea how your document is laid out - the expressions

If 1 "E1 " to be listed at the front of the document under condition rating 1 heading
If 2 "E1 " to be listed at the front of the document under condition rating 2 heading
If 3 "E1 " to be listed at the front of the document under condition rating 3 heading and also to be listed under the rear urgent section of the document.
If NI "E1 " to be listed at the front of the document under not inspected heading

are meaningless.

It is also difficult to see the point of the building block gallery. A listbox control would be clearer, however the syntax you are looking for is as follows. Replace the message boxes with the appropriate actions

Code:

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Select Case ContentControl.Range.Text
    Case "1"
        MsgBox "1 selected"
    Case "2"
        MsgBox "2 selected"
    Case "3"
        MsgBox "3 selected"
    Case "NI"
        MsgBox "NI selected"
    End Select
End Sub