View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default 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!