vba clear contents

[hoffies]

Hi Gurus

(searched other posts but none made sense to me)

I dont know how to copy an excel sheet into the question.

But assuming the following text starts at CELL C2 (this is just a section of the workbook)

C D E F G

1 x 5 5 Correct!
2 x 5 5 Try Again?
3 x 5 5 Try Again?
4 x 5 5 Try Again?
5 x 5 5 Try Again?


This is a worksheet to test multiplication tables. I am trying to create a macro button to clear the contents of column F, for the kids to start again?

Please assist ? THANK YOU in advance!

 

[Edmund]

Hi there,

Please help me with vba code. I have cell A1 and cell B1. In A1 cell is edited simple number. I need a vba code that clear A1 cell content when I type keyword "manual" in B1 cell . Thanks

 

[My Aswer Is This]

Try this:
To install this code:

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B1")) Is Nothing Then
If Cells(1, 2).Value = "manual" Then Cells(1, 1).ClearContents
End If
End Sub