Determine which button that started a macro

M

muffins

Board Regular
Joined
Jun 18, 2002
Messages
86
hi everyone,

i have add 3 buttons on my worksheet. these three buttons are assigned to the same macro.

how do i determine which button started the macro?

many, many thanks in advance.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
You could try:

Application.Caller

Test it out by putting

MsgBox Application.Caller

at the beginning of your code.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
VBA column print hyperlinks
2
Replies
10
Views
213
Micron
M
A
  • Question
Countdown timer on the userform.
Replies
9
Views
152
asyamonique
A
T
  • Solved
Copy worksheet to new workbook without formulas or macro button
Replies
9
Views
545
Tgrundy09
T
A
  • Solved
Command buttons not working when on different workbook
Replies
3
Views
175
Alan_CT06
A
A
  • Question
Help Using VBA To Create A Workbook Containing VBA
Replies
2
Views
400
Aldk_1
A

Forum statistics

Threads
1,214,896
Messages
6,122,132
Members
449,066
Latest member
Andyg666

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top