ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get a message pop up when a macro has run? (https://www.excelbanter.com/excel-discussion-misc-queries/234117-how-get-message-pop-up-when-macro-has-run.html)

LousieRobinson

How to get a message pop up when a macro has run?
 
I have a simple macro which transfers a persons details to a different page.
It runs by clicking a button. I would now like to have a message pop up when
the macro has run maybe in a pop up box. Is this possible?


JE McGimpsey

How to get a message pop up when a macro has run?
 
One way:

Put this line of code just before the End Sub line:

MsgBox "Macro has finished running"

In article ,
LousieRobinson wrote:

I have a simple macro which transfers a persons details to a different page.
It runs by clicking a button. I would now like to have a message pop up when
the macro has run maybe in a pop up box. Is this possible?


LousieRobinson

How to get a message pop up when a macro has run?
 
Thank you really helped, all works as well. Very grateful!

"JE McGimpsey" wrote:

One way:

Put this line of code just before the End Sub line:

MsgBox "Macro has finished running"

In article ,
LousieRobinson wrote:

I have a simple macro which transfers a persons details to a different page.
It runs by clicking a button. I would now like to have a message pop up when
the macro has run maybe in a pop up box. Is this possible?




All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com