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!