VBA command button for running a macro-module

[epicdonk]

Hi all,

I am new to this site although it is since a while that the latter has been helping me to solve excel problems.
I am starting to creating VBA code in order to make my life easier.

The problem is the following:

I created a Button (form control) on a certain sheet and then I assigned a macro to it but it does not work.

That is the code within my module:

Private Sub Delete_Click()

Application.Workbooks.Worksheets("1. Conversion").Activate

Range("FULL_YEAR").ClearContents

Range("YEAR_TO_DATE").ClearContents

Range("G3").ClearContents

Application.Workbooks.Worksheets("1. Converison").Activate

Range("A1").Activate

End Sub

But the problem is that when I try to click on the button, nothing happens...however, when I choose to manually run my macro, it says:

-- removed inline image ---


Thank you in advance for your response!

P.S: Sry for my english

BR,
Epicdonk

 

[epicdonk]

Hey all,

Sry I tried to insert a printscreen from the problem. I have got a message error saying: Ambiguous name detected: Delete_click.

Thanks!

Epicdonk