Action depending on cell Value
Could you build on this?
Private Sub Worksheet_Change(ByVal Target As Range)
If Cells(1, 1).Value < 10000 Then
MsgBox ("Do Something")
Else
MsgBox ("Do Something else")
End If
End Sub
Mike
"Tomas Stroem" wrote:
Hi,
I am trying to get a Macro that create one thing if a Cell Value in a
specific cell is lower than 10000, and something else if the same value is
higher than or equal to 10000.
How do I make this happen?
--
Tomas S
|