Ger
02-29-2008, 05:26 AM
Hi,
I want a msg box displayed if the value of 2 cells is not equal.
I know i must put the macro in the worksheet with the option change.
the cells are GE141 and GE142.
I think it looks like:
Private Sub Worksheet_Change(ByVal Target As Range)
If Then
MsgBox "deze invoer is onjuist"
End If
End Sub
Ger:help
I want a msg box displayed if the value of 2 cells is not equal.
I know i must put the macro in the worksheet with the option change.
the cells are GE141 and GE142.
I think it looks like:
Private Sub Worksheet_Change(ByVal Target As Range)
If Then
MsgBox "deze invoer is onjuist"
End If
End Sub
Ger:help