Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click Event
Arr yes thats exactly what I was looking for
Thanx Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListBox Click Event | Excel Discussion (Misc queries) | |||
On click button event | Excel Worksheet Functions | |||
CommandBarButton click event | Excel Programming | |||
Single click event | Excel Programming | |||
Mouse Click Event | Excel Programming |