Thread: halting macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_3_] Patrick Molloy[_3_] is offline
external usenet poster
 
Posts: 27
Default halting macro

For example

IF Msgbox("Continue?",vbYesNo,"Pause")=VBNo Then
Exit Sub
End If

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi again,
lots of questions from here and thanks for all the good

answers! Really
helped.

Another question is how to make a dialogbox where you

answer a question
(yes or no answer) were a positive answer would continue

to run the
reminding macro while a negative answer would halt the

macro right
there.

Is there such an code to resolve this as well?

Kind regards

Jonas

*** Sent via Developersdex http://www.developersdex.com

***
Don't just participate in USENET...get rewarded for it!
.