Click Event

[Guest]

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

 

[Doug Glancy]

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

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.

 

[Guest]

Arr yes thats exactly what I was looking for

Thanx Doug