How VB code can unhide/hide rows based on combobox selection?

Good morning… I have the code you see below that works but I would like to add to it because the drop down box has multiple choices.
What I have works… I just don’t know how to add to it. This is what I would like for it to do:

If “RE” or “Both Non-RE & RE” are selected I would like rows 88:89 & 99:102 to be unhidden

If “NON-RE” is selected I would like for row 99 to be unhidden

I am trying to learn… just a slow process.

Formula:

'Collateral type'

Private Sub ComboBox5_Change()



Dim Rng As Range



Rows("91:102").Hidden = 1



If ComboBox5.Value <> "" And ComboBox5.Value <> "Unsecured" Then

    Set Rng = Range("A91:J102")

    Rng.Resize(1 * ComboBox5.Value + ComboBox5.Value - 1).EntireRow.Hidden = 0

End If

   

End Sub