Explain a little more by what you mean by "form" -- are you talking about a
UserForm that has entry fields in it, or are you writing about a worksheet
that is laid out and used as a 'form" for users to put information into
certain required cell locations on it?

In both cases, the answer is YES, you can validate entries before
continuing. How you do it depends on what you are using as a form. If it is
a worksheet being used as a form, then you can do this with the workbook's
_BeforePrint() and _BeforeSave() event handlers. For a UserForm, you'd have
to put the code into the UserForm's code area and exactly where to put it
depends on the form's setup.


"shepherdess" wrote:

Is it possible to have required fill-in cells in a preformatted form? Say,
the completer cannot leave the field or save the file unless the required
fields are completed?

Thanks in advance for any help you can give me on this one.