View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Need help with message box.

Or, to use your references:

If Cells(22, 11).Value = "QS" Then
MsgBox "New code"
Exit Sub
End If

if you do not want this to be case sensitive:

If UCase(Cells(22, 11).Value) = "QS" Then
MsgBox "New code"
Exit Sub
End If


---
Regards,
Norman



"Norman Jones" wrote in message news:...
Hi Pat,

Try:

If Cells(1, 1).Value = "QS" Then
MsgBox "New code"
Exit Sub
End If


---
Regards,
Norman