You can setup a variable or property that both the form and the macro have
access to.
In the Cancel buttons cick event set the variable.
In your macro you will have to add DoEvents then after the DoEvent check if
the variable has been set and exit the macro if set.

Fred

"Amir" wrote in message
...
Hi,

I have a macro which takes a long time to run.

During the macro operation there is a form showing that the macro is
currently 'running'.

Which commands should I put in that form's Cancel button so that it with
cancel the macro operation?

I guess I should put some DoEvents lines in my macro code for that to
work, but I don't know the commands for the cancel button.

Guess the macro name is MyMacro.


Kind Regards,
Amir.