Click Event
 

Hope someone has a solution for me.

I want to create one macro that responds to clicks from several buttons/shapes and knows which particular button was clicked to run the macro.

Thanx

Click Event
 

Nichevo,

You can use something like the following with shapes or buttons from the
forms toolbar. Just right-click on the button or shape and assign the
macro:

Sub who_called()
MsgBox Application.Caller
End Sub

hth,

Doug

"Nichevo" wrote in message
...
Hope someone has a solution for me.

I want to create one macro that responds to clicks from several
buttons/shapes and knows which particular button was clicked to run the
macro.

Thanx

Click Event
 

Arr yes thats exactly what I was looking for

Thanx Doug