Results 1 to 11 of 11

Calling an image "alt text" for use in a macro?

Threaded View

  1. #8
    Registered User
    Join Date
    12-18-2008
    Location
    White Rock
    Posts
    76

    Re: Calling an image "alt text" for use in a macro?

    Alright, I tried changing the " Sheets(1) " to " ActiveSheet ", but I'm getting the same error of " Shapes(Application.Caller) " returning error 2023.

    This is all hapening within the VB debugger?

    Whenever I try to use the " Sheets(1).Shapes(Application.Caller).AlternativeText " as a value or in conjunction with a string, Application.Caller errors out.

    Specifically what I would be looking for is something along the lines of the following pseudo-code:

    Declare testString to be a String variable
    Set the value of testString to " ActiveSheet.Shapes(Application.Caller).AlternativeText "
    Print out in cell C6:
     "The serial number of this item is [whatever the value of testString is] have a nice day."
    I hope that is even possible.

    Thank you for your patience,

    -Aaron
    Last edited by Cheshire; 08-21-2009 at 01:43 PM.

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