Message prompting that macro run is finished.

**rain4u** · 02-16-2011, 05:47 AM

Is there a line that I can add to my macro that notifys me with a message that the macro is finished its run/complete etc.

**Colin Legg** · 02-16-2011, 05:53 AM

Hi,

Please Login or Register  to view this content.

Put it in your code just before the exit point (probably just before the End Sub or End Function line)

**rain4u** · 02-16-2011, 04:36 PM

works as advertised
Cheers

**gbyrka** · 06-13-2013, 11:38 AM

Hello,
Thank you but the message pops up at the 1st occurrence found, not when all characters have been replaced. FYI:

Sub CleanseCarriageReturn()
'
' CleanseCarriageReturn1 Macro
'

'
Cells.Replace What:=Chr(13) & Chr(10), Replacement:=" ", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
MsgBox "Complete"
End Sub

Is there a way to have it displayed once the macro is 'really' finished?
Thank you for your help!
Greg