.
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 :
If you wanted to run a macro named ThisIsMyMacro :Sub Commandbutton4_Click () End Sub
Then the code for the button would be :Sub ThisIsMyMacro () 'code for this macro goes here End Sub
Sub Commandbutton4_Click () ThisIsMyMacro End Sub