msg box help

S

sally

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

Bob Phillips

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)
 
Top