VBA Code to Extract Text from the Button/Macro I select

[OilEconomist]

Thanks in advance for your assistance.

I have two macro buttons which I have assigned to the same macro. What I would like to do is modify how the macro is run when selecting the macro. So for example, let's say:

First Macro Button
Button Name: Button1
Text within Button1 - "Download"

Second Macro Button
Button Name: Button2
Text within Button1 - "Upload"

If I select Button1, the Macro will extract the text and run the Macro in 1 Scenario, but if I select Button2, the Macro will run in an alternate scenario.

For example

Sub MacroButtonRun()

Dim MacroString as text

'Get the text from the Macro button I select where the text will be MacroString

If MacroString = "Download" Then
    'do this
ElseIf MacroString = "Upload" Then
   'do this
Else
  MsgBox "Possible "Error!"
End If

End Sub

 

[Siddharth Rout]

You mean like this?

Sub MacroButtonRun()
    Dim MacroString As String
    
    MacroString = ActiveSheet.Buttons(Application.Caller).Caption
    
    MsgBox MacroString
End Sub

 

[OilEconomist]

You mean like this?

Sub MacroButtonRun()
    Dim MacroString As String
   
    MacroString = ActiveSheet.Buttons(Application.Caller).Caption
   
    MsgBox MacroString
End Sub

Exactly like that! Thanks so much @Siddharth Rout for not only responding, but responding so quickly!