Just an idea. Why don't you conditional format all these input cells. When
blank, put a color. So once the user has completed the form, he can easily
see the blanks which are colored.

Mangesh



"Sandy" <[email protected]> wrote in message
news:[email protected]...
> Hi Dominic -
>
> Thanks for your response. There are actually 64 cells that need to be
> validated on one sheet and eight on another. As people work on these,
they
> don't for example, always have all of the answers and partially fill out
the
> form until they get them. When it is finally submitted, it is easy for
them
> to miss a couple. In other words, sometimes, they don't enter a cell yet.
> Therefore, validation upon leaving won't work.
>
> I am used to working with .Net which makes validation easy. If something
> isn't filled in and a submit button is clicked, a list of incorrect/blank
> answers can be returned to them. I was looking for this type of
> functionality.
>
> Any suggestions?
> --
> Sandy
>
>
> "dominicb" wrote:
>
> >
> > Good morning Sandy
> >
> > It is possible, but why not use the easier route of using Excel's
> > validation feature. Data > Validation will allow you to set parameters
> > up for any individual cell, and the validation rules will be checked
> > whenever the user attempts to leave a cell.
> >
> > HTH
> >
> > DominicB
> >
> >
> > --
> > dominicb
> > ------------------------------------------------------------------------
> > dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
> > View this thread:
http://www.excelforum.com/showthread...hreadid=398472
> >
> >