which shape clicked?

[hfli999]

Hi,

I have two shapes on a slide. Both needs to run same macro. Is there
way to know which one user clicked?

Thanks

 

[John Wilson]

In the brackets after the sub name enter 'oshp as Shape'

oshp will refer to the clicked shape

eg
Sub whatever(oshp As Shape)
MsgBox oshp.Name
End Sub
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

 

[hfli999]

Great. Thanks!

Is there any way to know where is my mouse pointer position in click
or mouse over macro?

 

[Steve Rindsberg]

Great. Thanks!

Is there any way to know where is my mouse pointer position in click
or mouse over macro?

Since you just clicked on or moused over the shape that triggered the macro,
you can always do:

Sub whatever(oshp As Shape)
MsgBox oshp.Top & vbcrlf _
& oshp.left & vbcrlf _
& oshp.height & vbcrlf _
& oshp.width
End Sub

In other words, you know the mouse is somewhere within the shape.

Or did you need more precision than that?