ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pause a Macro (https://www.excelbanter.com/excel-programming/392614-pause-macro.html)

MESTRELLA29

Pause a Macro
 
I need help with the following:
I dowload data form a server and put this on the clipboard, the Macro1 paste
this data then cleans it up and arrange it the macro works well,

I need is to Pause the macro with a Question like "would you like to import
US now? if yes let me get the data and put it in the clipboard and when this
is done run the macro2 for the US download.

Did I made mi self clear?

Charlie

Pause a Macro
 
If MsgBox("Import Now?", vbYesNo) = vbYes Then
GetData
PutInClipboard
Macro2
End If


"MESTRELLA29" wrote:

I need help with the following:
I dowload data form a server and put this on the clipboard, the Macro1 paste
this data then cleans it up and arrange it the macro works well,

I need is to Pause the macro with a Question like "would you like to import
US now? if yes let me get the data and put it in the clipboard and when this
is done run the macro2 for the US download.

Did I made mi self clear?



All times are GMT +1. The time now is 09:41 AM.

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