Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default 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?




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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?






Reply
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
Function Arguments dialog vanishes when clicked an inserted shape RK Excel Worksheet Functions 2 February 2nd 09 07:58 AM
enter time when shape is clicked Dgwood90 Excel Discussion (Misc queries) 1 October 15th 08 10:31 AM
XL2000: Shape object events GSQUARED Excel Programming 1 October 22nd 03 05:15 PM
detecting shape clicked on notsureofthatinfo Excel Programming 1 October 15th 03 07:46 AM
Hyperlink within the TextFrame of Shape Object..? Robert Stober Excel Programming 0 October 12th 03 10:05 PM


All times are GMT +1. The time now is 04:27 AM.

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

About Us

"It's about Microsoft Excel"