Form - select button & retrieve button name or button's caption

Maybe:

use the code

Private Sub UserForm_Initialize()
'
CommandButton1.Tag = "CommandButton1"
CommandButton2.Tag = "CommandButton2"
CommandButton3.Tag = "CommandButton3"
CommandButton4.Tag = "CommandButton4"
CommandButton5.Tag = "CommandButton5"
'
End Sub

Private Sub CommandButton1_Click()
'
MsgBox "Caller = " & CommandButton1.Tag
'
End Sub

Private Sub CommandButton2_Click()
'
MsgBox "Caller = " & CommandButton2.Tag
'
End Sub

Private Sub CommandButton3_Click()
'
MsgBox "Caller = " & CommandButton3.Tag
'
End Sub

Private Sub CommandButton4_Click()
'
MsgBox "Caller = " & CommandButton4.Tag
'
End Sub

Private Sub CommandButton5_Click()
'
MsgBox "Caller = " & CommandButton5.Tag
'
End Sub

Hi,

Thanks for your help, however i still could not figure out what how to fix this.

Please Login or Register  to view this content.

So in plain language, when any of the 4 buttons being clicked, it will call BN50_Send_no_Payment_file.
However depending on which one that has been clicked, i need to configure which file to get & who to send it.



I have attached sample for your consideration.

Thanks
Lex

Thanks XLNitWit.

It works perfectly.

Regards
Albert