How to tell what button was clicked

[Foo_Man_Chu]

Ok, so I have 12 ActiveX buttons on my spreadsheet. I want to run a single Sub if any of them are clicked, but I need to know what button was clicked so that I can change the color of the button that was just clicked. I've searched around and have found some almost there answers but nothing that worked for me. Any help rendered would be very much appreciated.

 

[My Aswer Is This]

I think you should put a script something like this in your button script.
Now when the button is clicked the color can be changed.
I have provided some other elements of the button that can be changed also.

Private Sub CommandButton1_Click()
With CommandButton1
.Caption = "I Was Clicked"
.ForeColor = vbBlack
.BackColor = vbRed
.Font.Size = 16
.Font.Bold = True
End With
End Sub