Is there away I can but a button or something like that

[rcirone]

Is there away I can but a button or something like that. That when press it will clear all content for a lot of cell but they are not all in the same row

 

[Joe4]

You can create a button to run any VBA procedure that you create.
All you have to do is create your VBA procedure, and then assign that procedure to a command button (see How To Add A Form Control Button To Run Your VBA Code | How To Excel).

As for creating the VBA code, if you need help with that, you will need to provide a lot more details than you have!

 

[rcirone]

You can create a button to run any VBA procedure that you create.
All you have to do is create your VBA procedure, and then assign that procedure to a command button (see How To Add A Form Control Button To Run Your VBA Code | How To Excel).

As for creating the VBA code, if you need help with that, you will need to provide a lot more details than you have!

I need A4:Q40 and x4:x40 , cells Y4, c154 to c166 I need all the cell I listed to clear all content when I hit the button.

Thanks for your help

 

[Joe4]

Pretty straightforward procedure.

Sub MyClearCells()
    Range("A4:Q40").ClearContents
    Range("X4:X40").ClearContents
    Range("Y4").ClearContents
    Range("C154:C166").ClearContents
End Sub

If you need to make changes to it, it should be pretty easy to see how to do that.

 

[Joe4]

You could also do it in one line, like this:

Sub MyClearCells2()
    Range("A4:Q40, X4:X40, Y4:Y4, C154:C156").ClearContents
End Sub

 

[rcirone]

Pretty straightforward procedure.

Sub MyClearCells()
    Range("A4:Q40").ClearContents
    Range("X4:X40").ClearContents
    Range("Y4").ClearContents
    Range("C154:C166").ClearContents
End Sub

If you need to make changes to it, it should be pretty easy to see how to do that.

Thanks it works

 

[Joe4]

You are welcome.