is it possible: If Me.Controls("CommandButton" & i).clicked

[kofatoto]

hello
is it possible:

If Me.Controls("CommandButton" & i).clicked Then
Sheets("tt").Range("C" & i).Value = Me.Controls("CommandButton" & i).Caption
End If

[mdmackillop]

You could build a Class for Command Buttons (http://www.vbaexpress.com/kb/getarticle.php?kb_id=85) or

Private Sub CommandButton1_Click()
Call FillCell(1)
End Sub
Private Sub CommandButton2_Click()
Call FillCell(2)
End Sub


Sub FillCell(i)
Sheets("tt").Range("C" & i).Value = Me.Controls("CommandButton" & i).Caption
End Sub

[kofatoto]

thank you very much