If Range("A1")/Range("A2") < 30 Then
MsgBox "Message 1"
End IF

If Range("C3")/Range("C4") < 5 Then
MsgBox "Message 1"
End IF

What about = 30 and = 5?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"sally " wrote in message
...
I have prepared this spread sheet for recording contributions made by
members of my bridge club.
However i need a vba codes that will compare four cells and based on
certain conditions activate a msg box.
eg if A1/A2 < 30 pop up a message but do nothing if 30 and also if
C3/C4<5 pop up a different message this time a yes/no/ok msg box but
nothing if 5. Is this possible ?
sally


---
Message posted from http://www.ExcelForum.com/