COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
wrote:
naga rajan wrote:
I need a msgbox to pop up if either A1 or B1 greater than C1.
[....]
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value Or Range("B1").Value Range("C1") Then
MsgBox "A1 or B1 is greater than C1", vbOKOnly, "High Hopes"
End If
End Sub
Correction:
If Range("A1") Range("C1") Or Range("B1") Range("C1") Then
Also note that the Worksheet_Change event macro goes into a worksheet
module, not a normal module. Right-click on the worksheet tab to open the
worksheet module in the VBA window.
|