I'd need to insert an option on my macro where if yes is selected the macro
will keep running. If cancel is selected the macro will stop and no changes
are made.

Try some code like

Dim Res As Long
Res = MsgBox("Do you want to continue?", vbYesNo)
If Res = vbNo Then
Exit Sub
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Qaspec" wrote in message
...
I'd need to insert an option on my macro where if yes is
selected the macro
will keep running. If cancel is selected the macro will stop
and no changes
are made.

Hi, try:

If vbCancel = MsgBox("Continue process?", vbOKCancel, "Process") Then
MsgBox "Process cancelled"
Exit Sub 'Process cancelled
End If
MsgBox "Process continuing"

Regards,
Sebastien

"Qaspec" wrote:

I'd need to insert an option on my macro where if yes is selected the macro
will keep running. If cancel is selected the macro will stop and no changes
are made.