So I've just learnt from [here](https://stackoverflow.com/questions/17035660/vba-excel-get-rid-of-the-case-sensitivity-when-comparing-words) about the "Option Compare Text" and "Option Compare Binary" to differentiate between case-sensitivity for the .Match function.

Right now, this if-else statement shows what I'm trying to do (albeit with errors):

```
If dictionaryData.Cells(4, 2).Value = "Yes" Then
    caseSensitive = True
    NetworkNameDict.CompareMode = vbBinaryCompare
    Option Compare Binary
Else
    caseSensitive = False
    NetworkNameDict.CompareMode = vbTextCompare
    Option Compare Text
End If

```

I need this if else statement to check if the user wants to compare by case-sensitivity. The "Option" is placed in there for my .Match function to work (found later in the codes).

I understand that the "Option" codes has to be typed at the top, but I need this option to stay dynamic due to this option being given to users to set in the spreadsheet.

So my question is, is there any way to somehow do a case-sensitivity setting for the .Match function in an if-else statement?