Excel macro help needed

Joined
Oct 20, 2016
Messages
1
Reaction score
0
Hi all,

I would like to clear the contents in a selection of cells and clear a checkbox with the use of a command button.

I have written a macro that will allow me to clear the cells contents:

Range( _
"F5,F6,A6:E6,C9,C22,D18,F9,C10:F10,C11:F11,B14,D14,B18,C23,C26:E27,C28:E28,C33 ,E32" _
).Select
Range("E32").Activate
Selection.ClearContents
End Sub

this works fine but I have been unable to include the checkbox in this.

I have found a way to clear the checkbox by editing the code on the "sheet1" tab:

Sub UnCheckBox()

With Sheet1

.CheckBoxes.Value = False

End With

End Sub

I would like to be able to combine both of these routines so that I can use one button, I am very new to working with excel in this way so any help would be greatly appreciated.

Thanks.
 
Back
Top