| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code ... Run-skip-run ... Code
Excel2003 ... I have Macros (note: I record only, then cut/paste) where I
have a MsgBox (YES/NO) where ... YES = continue running Macro ... NO = Exit Sub ... These work fine ... However, in addition to above ... I would like simplified Code that will allow for ... Run/Skip/Run ... in addition to Run/Exit (above). ie: I have 1000 lines of Code & I want a YES/NO option to run lines 400-600 or skip these lines ... Run Macro = Run lines 1-399 ... YES/NO Msg Box ... YES = Continue running lines 400-1000 NO = Skip lines 400-600 ... resume running @ line 601-1000 Note: I need capability to edit the YES/NO & what is Run/Skipped so I can use these edited lines of Code in other Macros where I wish to ... Run/Skip/Run ... Gord Dibben has provided a lot of guidance (separate post & my sincere Thanks) ... However, based on his latest response I am now posting this question to the Programmers ... Thanks ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros skip steps and/or stops in the middle of code | Excel Programming | |||
| How to have a Macro skip code if PivotTable/PivotField is not there | Excel Programming | |||
| skip some code | Excel Programming | |||
| skip code | Excel Programming | |||
| Excel skip some lines of VBA code | Excel Programming | |||
Threaded Mode
