In VBA, I'm trying to Split the below sample string in arrays using a char # first and again split the value in each array location using the char :, how can we achieve it.

category:agenda#construct:area graph#ink\_ratio\_bus:#has\_image:#image\_size:#has\_icons:n#color\_type:#has\_cartoon:#has\_three\_d:#has\_shading:#shape:#has\_graphs:#has\_tables:#sid:0003#parent:amod\_test#parent\_sid:#node:#theme:default

I tried the following but null value creates error in this function

```
  Dim subVals() 
  subVals = Split(oSh.TextFrame.TextRange.Text, "#")
                    cmbConstruct.Value = Right(subVals(1), Len(Left(subVals(1), 10)))
                    cmbInk.Value = Right(subVals(2), Len(Left(subVals(2), 6)))
                    cmbImages.Value = Right(subVals(3), Len(Left(subVals(3), 1)))
                    cmbImageSize.Value = Right(subVals(4), Len(Left(subVals(4), 1)))

```