Dear all,

would love some help here regarding writing a macro

Situation:
I have a google form that allows for people to fill in their answers. One of the questions is a multi-check box.
For illustrative purposes, it looks like this:

To my knowledge, the member has claimed the following benefits (can select>1):
- PG
- CHAS
- FDW
- SMF
- IDAPE

The recorded answers appears in an excel sheet in the form of: PG,CHAS,FDW,SMF (depending on what the person choose). Note that the answers are all in one box.

I have created a word document with the exact same question (with check-boxes each with their own bookmark)-- and would like them to be auto-ticked based on the answer recorded in the excel. As the answers are in one box, it seems like the macro only reads the answer as one answer instead of being able to split it up. Thus, none of the answers gets ticked.

Macro used:

Dim claimed As String
claimed = rowData(j, 18)

Select Case claimed
Case "Pioneer Generation (PG)"
wddoc.Bookmarks("PG").Range.InsertAfter Text:=ChrW(&H2713)
Case "CHAS"
wddoc.Bookmarks("CHAS").Range.InsertAfter Text:=ChrW(&H2713)
Case "Eldershield"
wddoc.Bookmarks("Eldershield").Range.InsertAfter Text:=ChrW(&H2713)
Case "IDAPE"
wddoc.Bookmarks("IDAPE").Range.InsertAfter Text:=ChrW(&H2713)
Case "Seniors' Mobililty & Enabling Fund"
wddoc.Bookmarks("SMF").Range.InsertAfter Text:=ChrW(&H2713)
Case "EASE"
wddoc.Bookmarks("EASE").Range.InsertAfter Text:=ChrW(&H2713)
Case "Foreign Domestic Worker (FDW) Grant"
wddoc.Bookmarks("FDW").Range.InsertAfter Text:=ChrW(&H2713)
End Select

Is there any way to go about it? Or am I better of pasting it all as one answer.

Would appreciate all the help I can get! More details in the attachments.

Word doc
chas.png

Excel
CHAS 1.png