Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Abort or continue

try this... may be easier than another window / form...

..
..
..
Dim i_Rtn as Integer

i_Rtn = MsgBox("what do you want to do?", vbYesNoCancel +
vbQuestion + vbDefaultButton2, "MyAppName")

' Check the MsgBox return code.
Select Case i_Rtn
Case vbYes
' Continue running code
Case vbNo
' Stop running code
Case vbCancel
' Cancel the whole thing, and the user will start
again later
End Select
..
..
..


-----Original Message-----
how do you have the option in code to have a popup that

will let you
continue or quit a code
what I am trying to do is when someone checks a

checkbox, is to give them
the option to continue or quit before the rest of the

code runs


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Continue Quote Kev Setting up and Configuration of Excel 1 August 8th 09 04:19 PM
How to abort a w/s calculation in real time? [email protected] Excel Discussion (Misc queries) 7 June 19th 08 04:42 PM
to continue down in the same row alex178 Excel Discussion (Misc queries) 2 July 8th 06 05:34 PM
continue VLOOKUP to next value rich Excel Worksheet Functions 1 May 24th 06 02:02 AM
Abort or continue Ed Ferrero[_4_] Excel Programming 0 August 5th 03 02:01 AM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"