MsgBox to return to the last opened worksheet

[LFKim2018]

after a macro is executed, I don't want it to exit excel (or proceed with the command) right away -I would like to insert a MsgBox with these buttons - (1). return (defer the command or do not exit excel but return to the last opened sheet) this is the default button (2). continue with the command or exit excel
How would the vba macro be written?
Thank you

 

[ranman256]

cant. Msgbox only has YES,NO,CANCEL.
so , you must use a userform
put the 3 options on the form, code each button to do what you want.

load the form:
myForm.Show