ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prompt to say complete when macro hasd completed task (https://www.excelbanter.com/excel-programming/366598-prompt-say-complete-when-macro-hasd-completed-task.html)

bsnapool[_4_]

Prompt to say complete when macro hasd completed task
 

Hi

Wondering if anyone can help me?

I have code which when run copys the master sheet to a value in a
cell.

I am looking for a prompt to appear when the macro has run and
completed the task to say "task completed"

Any ideas??

Thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=559417


Tom Hutchins

Prompt to say complete when macro hasd completed task
 

....
MsgBox "Task completed"
End Sub

"bsnapool" wrote:


Hi

Wondering if anyone can help me?

I have code which when run copys the master sheet to a value in a
cell.

I am looking for a prompt to appear when the macro has run and
completed the task to say "task completed"

Any ideas??

Thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=559417




All times are GMT +1. The time now is 02:35 AM.

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