1st post here ... gentle on a vba newbie
I have a few pictures on a sheet
I'd like to return the AlternativeText from whatever picture the user clicks
(Then eventually, i'll find that Alt-Text on another sheet)
I found the property AlternativeText for Shape and ShapeRange ... but not sure how to get this for the clicked picture .... what i'm looking for:
Sub subPicture_Click()
' varAltTxt = Selection.ShapeRange.AlternativeText
' varAltTxt = ActiveWindow.Selection.Shape.AlternativeText
' (^bombs out on both of these^)
' do other stuff with varAltTxt
End Sub
Thanks In Advance
Bookmarks