ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to tell wich object/shape was clicked (https://www.excelbanter.com/excel-programming/284015-how-tell-wich-object-shape-clicked.html)

Harald Staff

How to tell wich object/shape was clicked
 
Hi

Su
MsgBox Application.Caller

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Andrew Ofthesong" skrev i melding
...
Hi.. i've found a code that can be applied to powrpoint VBa in order to

tell
wich shape youhave clicked on (So you can assing 20 shapes the same macro,
and with "IF" do different things)

Is there a way to do a smililar thing in excel?





Andrew Ofthesong

How to tell wich object/shape was clicked
 
Hi.. i've found a code that can be applied to powrpoint VBa in order to tell
wich shape youhave clicked on (So you can assing 20 shapes the same macro,
and with "IF" do different things)

Is there a way to do a smililar thing in excel?



Andrew Ofthesong

How to tell wich object/shape was clicked
 
Wow!.. thanks!

"Harald Staff" escribió en el mensaje
...
Hi

Su
MsgBox Application.Caller

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Andrew Ofthesong" skrev i melding
...
Hi.. i've found a code that can be applied to powrpoint VBa in order to

tell
wich shape youhave clicked on (So you can assing 20 shapes the same

macro,
and with "IF" do different things)

Is there a way to do a smililar thing in excel?








All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com