Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would guess each rectangle has an on_click event so just pass some
indentifier as an arguement to your macro. Something like this Private Sub Rectangle1_Click() yourmacro "rec1" End Sub Private Sub Rectangle2_Click() yourmacro "rec2" End Sub then for your macro Sub yourmacro(WhichRectangle as String) your code here End Sub the value WhichRectangle will tell you what was clicked to start your macro Paul D wrote in message ... I have a macro assigned to a number of rectangles. When a specific rectangle is clicked to activate the macro, I need the macro to identify which rectangle (ex: "Rectangle 3") was clicked to activate the macro. How would I do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
selection from dropdown list activates hyperlink | Excel Discussion (Misc queries) | |||
Special Menu activates Web Toolbar | Excel Discussion (Misc queries) | |||
Delete a rectangle using a macro | Excel Discussion (Misc queries) | |||
VB activates unwanted function | Excel Programming | |||
Solver activates other worksheets - why? | Excel Programming |