Thread: Click Event
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default 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