LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default XL2000: Shape object events

Hi,

I have several Rectangle shapes on a worksheet. I would like to assign
a generic macro (sub) to each of them, but using the Name of the shape
in the macro.


i.e. objShape1, ObjShape2 two shape objects
assign macro : Generic_Macro to both

Sub Generic_Macro()
MsgBox <triggeringshape.Name
End Sub

can this be done? Or could I "morph" a rectangular shape object in a
class module and write some special event for the OnAction event of
the shape?

Question 2: is there any way to have a MouseOver event triggered for a
Shape?


Thanks in advance!
Gyula
PS: please email to
 
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
monthly cycle events to add to calendar object jforbes Excel Discussion (Misc queries) 7 October 8th 07 08:35 PM
my curser changed from arrow shape to a cross shape???? bj New Users to Excel 1 February 5th 07 02:47 PM
Hyperlink within the TextFrame of Shape Object..? Robert Stober Excel Programming 0 October 12th 03 10:05 PM
How to hide Excel window when activating a Shape object Yi[_2_] Excel Programming 4 October 8th 03 02:36 PM
How to hide Excel window when activating a Shape object Bob Kilmer Excel Programming 0 September 27th 03 03:51 PM


All times are GMT +1. The time now is 05:19 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"