#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Click Event

Arr yes thats exactly what I was looking for

Thanx Doug
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ListBox Click Event BHatMJ Excel Discussion (Misc queries) 6 June 21st 07 09:34 PM
On click button event [email protected] Excel Worksheet Functions 1 November 30th 06 04:39 PM
CommandBarButton click event Javi Excel Programming 0 November 3rd 03 03:05 PM
Single click event isy Taman Excel Programming 1 August 10th 03 02:58 AM
Mouse Click Event Srinath Excel Programming 2 July 18th 03 04:03 AM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"