Zend certified PHP/Magento developer

Add text to a cell based on another cell’s value located in another sheet

I’m new to VBA and I’m trying to use this VBA I found but I need:

  • To check the value Column J, Sheet10, cell J9 and under. Only check for numeric values.
  • If numeric value is greater than 1, add “Testing” text to Column F, Sheet 10, cell F9 and under.
  • If numeric value is removed from check column, to remove the “Testing” text.

This is what I have. :/

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Range("E10").Value > 1 Then
    Range("F10").Value = "Testing"
    Else

End If

End Sub

I appreciate any help!