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.
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.