msg box help

  • Thread starter Thread starter sally
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

msg box 4
Message box warns for duplicate use of named ranges when copying s 1
msg box to display specials 2
Msg Box Help 1
msg Box Value to be Saved File Name ?? 5
MSG BOX PREVENTS setfocus HELP 6
msg box within a macro 3
How to create msg box if a cell contains value < 0 2

Back
Top