Message Box Question

[Drewgarry007]

I want to create a "Do you want to update shreadsheet before continuing" message box which will allow person runing the macro to amend the data in the spreadsheet before running the rest of the macro I have written.

Is this possible?

 

[VoG]

Try

If MsgBox("Do you want to update spreadsheet before continuing", vbYesNo + vbQuestion) = vbYes Then Exit Sub

 

[Drewgarry007]

Then if the user presses "yes" and updates the spreadsheet, how do they then continue the macro from when it was stoped by the message box ?

 

[VoG]

They would need to run the macro again.

 

[Drewgarry007]

Hmmm it wont work if i have to run the entire macro script again from the start. This message box would be halfway down the code I have written and would want to continue from that point ?