August 29, 2008 10:47pm pdt

1. zorvek 2,107,186
2. rorya 2,046,988
3. saurabh726 1,301,130
4. chris_bot... 776,246
5. byundt 680,182
6. nutsch 546,068
7. patrickab 412,280
8. jeverist 407,238
9. spattewar 316,278
10. matthews... 303,769
11. ahammar 281,891
12. webtubbs 256,684
13. jpaulino 245,997
14. RobSamp... 240,914
15. dj88 210,941
16. irudyk 163,728
17. WJReid 150,302
18. weellio 143,519
19. Psychotec 133,785
20. epaclm 119,855
21. GrahamSkan 107,769
22. jell 100,971
23. Merch_Ops 92,593
24. gtgloner 83,427
25. StellanRo... 80,929

1. zorvek 9,411,677
2. byundt 7,423,271
3. rorya 5,741,719
4. matthews... 2,866,897
5. jeverist 2,817,507
6. patrickab 2,167,843
7. roos01 1,919,714
8. mvidas 1,529,753
9. saurabh726 1,394,709
10. webtubbs 1,353,076
11. fanpages 1,234,722
12. brettdj 1,095,751
13. MalicUK 1,059,396
14. chris_bot... 965,752
15. mgh_mgh... 649,110
16. LoNeRaV... 602,049
17. ahammar 582,024
18. ture 570,551
19. nutsch 546,068
20. spattewar 525,227
21. R_Rajesh 468,975
22. jpaulino 358,896
23. david251 355,614
24. RobSamp... 339,463
25. sebastienm 339,407

06.19.2008 at 06:19AM PDT, ID: 23498697

	[x] Attachment Details

VBA to pause sub() execution, then resume when user wants it to

Asked by glennes in Microsoft Excel Spreadsheet Software, VB Script

Tags: Microsoft, Excel, 2003

At a point in the execution of a VBA script, I want execution to pause so the user can review the spreadsheet created up to that point, delete some unneeded rows if they are present, then resume execution by doing something -- maybe saying YES to an input box question, e.g., RESUME? -- , or any other similar convention. How can this be done in my VBA script?Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

           
           
             ....
... 
 
End With
    
    With SQLXL.Sql.Statements(3)
        .ShowParametersDlg = False
        .ShowResultsetDlg = False
    End With
    SQLXL.Sql.Statements(3).Execute
 
 
THE MACRO NEEDS TO PAUSE HERE FOR USER EDITS
THEN RESUME WITH EXECUTION OF THE NEXT STATEMENTS
BELOW.
 
    
    Range("L2").Select
    ActiveCell.FormulaR1C1 = "=RC[-6]*100"
    Range("M2").Select
...
....

           
         

Keywords: VBA to pause sub() execution, the…

	Title
1	Access VBA - Import Spreadsheet
2	Access VBA and Import Excel Spread…
3	VBA Code in Access to Open an excel…
4	Incorporating References to an AddIn …
5	VBA for Conditional Formatting in Excel
6	Vba conditional formatting based on cu…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

VBA to pause sub() execution, then resume when user wants it to

Asked by glennes in Microsoft Excel Spreadsheet Software, VB Script

Tags: Microsoft, Excel, 2003

About this solution