Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSG Box - Stop Macro
Why not just use the else criteria...
lastrow = Application.ActiveCell.Row If Range("k" & lastrow) = "Atty Fees" Then MsgBox "Complete Benefit Calc 1st" activecell.offset(1,0).select else 'Normal execution... end if -- HTH... Jim Thomlinson "Janet H" wrote: I have this line in my code - lastrow = Application.ActiveCell.Row If Range("k" & lastrow) = "Atty Fees" Then MsgBox "Complete Benefit Calc 1st" If the criteria causes the MsgBox to appear, I want to stop the process and return the user to lastrow + 1 What do I add to the end of the MsgBox line to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Stop | Excel Worksheet Functions | |||
How do I stop a macro from running within a macro? | Excel Programming | |||
Stop running a macro in the middle of a macro | Excel Programming | |||
Macro: With Stop it works. Without Stop it doesn't. | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |