Determine which button that started a macro

[muffins]

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.

 

[Andrew Poulsom]

You could try:

Application.Caller

Test it out by putting

MsgBox Application.Caller

at the beginning of your code.

 

[muffins]

wow... it works great!! thanks!!