LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Calling a Macro from multiple places in Excel sheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a Match in Multiple Places & Return Multiple Values Toria Excel Worksheet Functions 3 June 24th 08 09:49 PM
Multiple Check Boxes calling same macro Paul Excel Programming 3 July 11th 07 12:01 PM
How do I insert a copied the row to multiple places in Excel? Miranda Excel Discussion (Misc queries) 1 October 12th 06 03:51 PM
Calling Procedures from another excel sheet by passing objects Thomas Auburn Excel Programming 0 May 5th 04 05:33 PM
Excel Macro for multiple sheet ?? somu Excel Programming 3 February 14th 04 01:07 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"