I am asking about the first of your options---a standardized form for our
sales reps set up so that they cannot leave required fields blank. They enter
data into these fields---data that will be used by a programmer to prepare a
formatted quote for our product---prepared in other software.

Thank you so much for the information and your reply.

Shepherdess

"JLatham" wrote:

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.