The TargetFrame property returns or specifies the name of the target frame for a URL.
Examples:
The following VBA example displays the names of all targeted frames for the shapes on the page.
Sub Test()
Dim sh As Shape, s As String
For Each sh In ActivePage.Shapes
If sh.URL.TargetFrame <> "" Then
s = s & sh.URL.TargetFrame & vbCr
End If
Next sh
MsgBox "The current page contains the following URL target frames: " & vbCr & s
End Sub