Set row height based on the first 14 characters in a string

[Brian F]

Excel 2010; I am setting row heights on the basis of some parameters. I have the following statement;

If targetCell.Value = "Photo Comment: " Then
targetCell.RowHeight = 185

But what I really want is to recognize only the phrase;

"Photo Comment:" in a text string that might be much longer e.g,

"Photo Comment: The photo above depicts yata, yata.........."

So, I want to recognize the first 14 character as "Photo Comment:" and then have the row height adjust to 185. So it involves "Left" and "Len" (I'm thinkin') but the syntax is beyond me.

Any help would be greatly appreciated.

 

[JoeMo]

You didn't indicate the type of event you want to use so I'll assume it to be a worksheet change event which goes into a module for the sheet of interest:

Private Sub Worksheet_Change(ByVal Target As Range)
If InStr(1, Target.Value, "Photo Comment") > 0 Then
    Target.RowHeight = 185
End If
End Sub