Results 1 to 6 of 6

Excel 2007 : How to get clicked picture AlternativeText in VBA

Threaded View

frittob How to get clicked picture... 03-05-2009, 04:05 PM
Andy Pope Re: How to get clicked... 03-06-2009, 06:09 AM
frittob Re: How to get clicked... 03-06-2009, 09:18 AM
Andy Pope Re: How to get clicked... 03-06-2009, 09:20 AM
frittob Re: How to get clicked... 03-06-2009, 10:36 AM
Nioubie Function to get... 11-21-2011, 01:00 PM
  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    6-burg
    MS-Off Ver
    Excel 2007
    Posts
    6

    How to get clicked picture AlternativeText in VBA

    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
    Last edited by frittob; 03-13-2009 at 03:40 PM. Reason: Added code tags as per forum rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1