.
Using the image in your first post above ... you have apparently created a COMMANDBUTTON4.
The code that runs, when you click this button, is located in that area.

What it should look like is :

Sub Commandbutton4_Click ()

End Sub
If you wanted to run a macro named ThisIsMyMacro :

Sub ThisIsMyMacro ()
     'code for this macro goes here
End Sub
Then the code for the button would be :


Sub Commandbutton4_Click ()
ThisIsMyMacro
End Sub