View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Y2D3Y4 Y2D3Y4 is offline
external usenet poster
 
Posts: 2
Default How do I exit from a macro when a condition is not met

In Excel 2003 I have a macro that checks if a cell is not zero.

Range ("P124").Select
If Selection.Value < 0 Then
Call Check
End If

Sub Check()
Dim Msg, Style, Title, Response
Msg = "This JV does not balance, please correct it before you continue."
Style = vbOKCancel
Title = "Out of Balance
Response = MsgBox (Msg, Style, Title)
End Sub

I want to exit out of the macro routines when the user presses OK.

Thanks

Andy