Forgot the first bit

ans = MsgBox ("Hello",vbOKCancel)

then the rest.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
Matt,

Is your code like this

If ans = vbCancel Then
'quit code
End If


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matt" wrote in message
...
I have a Macro with an initial warning in the form of an
OkCancel MsgBox. On 'Ok' I want the macro to continue,
and on 'Cancel' I want it to stop entirely. When 'Cancel'
is pressed the macro does not stop. What am I missing?
Thanks.