Hi,
No idea - you will have to post an example macro. One possibility is
that a public variable called Cancel has been declared at the top of a
code module, so that it doesn't appear as a dim statement in the sub.
Another possibility is that the coder has not used Option Explicit at
the top of a module, so that this is a sub level variable. Yet another
possibility is that it says .Cancel = True (note the dot), and then
you proably have a Public variable declared in the code module behind
a Userform..
Impossible to say - post some code.

regards
Paul

universal wrote in message ...
Apologies if this is a simplistic question, but in order to help my
understanding of the macros that Ive been butchering and then adding
together, like a poor mans' Dr Frankenstein, I wondered what this
meant.

Cancel = True (and indeed Cancel = False) statements are littered
across some macros that I am using, before and after functions, and
dialogue boxes.

I wonder if anyone could explain how this actually works and what it
refers to, and when it should be used?

Many thanks for everybodies continued understanding & patience,
Ed


---
Message posted from http://www.ExcelForum.com/