Newb needs macro help with button and clearing multiple cells

[dwaynet19]

It amazes me how simple these issues come to some and how difficult they are for others. As much as I have tried and tried, macros are not my friend.

I am working on a mac. (excel for mac 2011)

I have a calculator type file which calculates totals 3 different columns.
I want to create a button which when I click, clears all the entries on all 3 different columns.
What do I need to do?

Scenario:

B2 = Button (when I click the button I want to clear the following)
B5,H5,N5 Individual cells to clear
D5;D23 J5;J23 P5;P23 columns I want to clear

 

[Nalani]

Try on a copy of your sheet:

Sub ClearCells()
    Dim myArea As Range
    For Each myArea In Range("B5,H5,N5,D5:D23,J5:J23,P5:P23").Areas
        myArea.ClearContents
    Next
End Sub

 

[dwaynet19]

ok I did that....
then asked to run the macro and nothing happened

 

[dwaynet19]

ok I did that....
actually, when I hit play, it cleared everything I wanted to

 

[Nalani]

Glad it worked for you. Thanks for the feedback

 

[Hashiru]

Hi

Try this.

Sub ClearCells()
Range(B5, H5, N5).Clear
Range(D5, D23, J5, P23, P5, P23).Clear
End Sub

 

[Hashiru]

Hi

Your reply is not clear, does the macro I sent did the work exactly you want?

 

[dwaynet19]

but how do I now create a button to run the macro?

 

[dwaynet19]

Hashiru.....
I did not try your macro.
What is the difference from yours and the first posted by Nalani?

Is there a difference?

 

[kpark91]

Developer Ribbon > Insert > Button > Place button on worksheet > double click button > copy + paste code into the code editor > go back to worksheet > disable design mode by clicking on it on the developer ribbon > click on your button > scream