Hi guys, I have an IF statement which checks what the value in a cell is then posts a score to another cell according to the value. It works fine, however whenever I click anywhere or do other tasks on the same sheet; the true value for the IF statement keeps firing - basically it adds +2 to the cell whenever I click somewhere.
Here's the code;
If Range("$Q$8") < 19 Then
Range("$Q$11") = Range("$Q$11") + 0
ElseIf (Range("$Q$8") >= 19 And Range("$Q$8") <= 25) Then
Range("$Q$11") = Range("$Q$11") + 2
ElseIf (Range("$Q$8") >= 26 And Range("$Q$8") <= 30) Then
Range("$Q$11") = Range("$Q$11") - 1
ElseIf (Range("$Q$8") >= 31 And Range("$Q$8") <= 40) Then
Range("$Q$11") = Range("$Q$11") - 3
ElseIf Range("$Q$8") > 40 Then
Range("$Q$11") = Range("$Q$11") - 5
Else: Range("$Q$11") = Range("$Q$11") + 0
End If
Thanks guys.
Bookmarks