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