VBA to cancel a macro

[GraemeG]

Hello.
I have the following code which runs a macro.
However I want to be able to give the users the option to cancel and not run the macro within the message box that appears.
Any help appreciated.
Thanks

Private Sub Command35_Click()
MsgBox "Warning! You must be connected to the network to syncronise survey data" & vbNewLine & "If you wish to procedd please select Ok" & vbNewLine & "If you do not wish to sync please select Cancel", vbExclamation + vbOKCancel, "Syncronise Data"
DoCmd.RunMacro "Output_Survey_Data"
End Sub

[ajetrumpet]

it should be:

if msgbox("warning!  yada yada...) = vbcancel then
   exit sub
else
   'run macro
end if