Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, it does.
In this case, the parent is the application. I don't think I've ever seen or used it in this way. Mike H wrote: Dave, Parent.caller works fine for me Mike "Dave Peterson" wrote: I think Mike meant Application.caller. Option Explicit sub testme() 'assigned to all the pictures Dim myPict as picture set mypict = activesheet.pictures(application.caller) msgbox mypict.name & vblf & mypict.topleftcell.address ' end wub Mike H wrote: Hi, Parent.Caller will give the name of the picture that called the macro Mike "Robert Reid" wrote: I am using Excel 2003. I have a worksheet with multiple pictures in it. When any of the pictures are clicked, a macro is called. I cannot figure out how to determine which picture was clicked to call the macro. Any help would be appreciated. I apologize if this is a question from VBA101. I'm kinda slow. :) -- Dave Peterson . -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
Multiple Check Boxes calling same macro | Excel Programming | |||
How do I insert a copied the row to multiple places in Excel? | Excel Discussion (Misc queries) | |||
Calling Procedures from another excel sheet by passing objects | Excel Programming | |||
Excel Macro for multiple sheet ?? | Excel Programming |