Better question. Why are you testing to see if the value is "greater than" and then in the next statement testing to see if the value is "less than"?
If the value is not equal, you only need one other if statement to get the two outcomes.
If colmod1 <> new_colmod1 Then
If colmod1 > new_colmod1 Then
colmod1 -= 0.001
Else
colmod1 += 0.001
End If
End If