Opv
02-16-2010, 11:51 AM
I found the following snippet and am trying to adopt it for my purposes. What I want to do is use the trigger cell (c2) to automatically clear the target range once the value of C2 is changed to "Yes" and then to automatically change the trigger cell back to "No."
I thought from the name of the Sub that it would place some sort of button for me to press to execute the code without having to go through so many different steps. On after thought, if there is a way to automate the entire process, as described above, that would be preferable.
Sub CommandButton_Click()
If [c2] = "Yes" Then
[C4:C500].ClearContents
End If
End Sub
Thanks,
Opv
I thought from the name of the Sub that it would place some sort of button for me to press to execute the code without having to go through so many different steps. On after thought, if there is a way to automate the entire process, as described above, that would be preferable.
Sub CommandButton_Click()
If [c2] = "Yes" Then
[C4:C500].ClearContents
End If
End Sub
Thanks,
Opv