I have a form in Excel with questions. For the Answer Column C, the user
should answer with either "1" or "2" They are not to leave it blank. The
questions go from C10 to C37. I have a hyperlink at the bottom that links to
another worksheet. I do not want them to be able to continue until they have
filled in cell, answering all questions with either a "1" or "2" Once they
finish the 2nd worksheet, They click End. I again want them to have to
answer each question. I am under a deadline and would greatly appreciate
anyone who can help me with a solution.
Thanks

You need to write a macro which will check whether all answers are checked in
and if not then stay on sheet 1. Put this on a continue button.

In the second do the same for the End button

Also in the Worksheet_Activate() method of sheet 2, you need to check
whether sheet 1 is complete, if not then activate sheet1 again...

"SueQueen" wrote:

I have a form in Excel with questions. For the Answer Column C, the user
should answer with either "1" or "2" They are not to leave it blank. The
questions go from C10 to C37. I have a hyperlink at the bottom that links to
another worksheet. I do not want them to be able to continue until they have
filled in cell, answering all questions with either a "1" or "2" Once they
finish the 2nd worksheet, They click End. I again want them to have to
answer each question. I am under a deadline and would greatly appreciate
anyone who can help me with a solution.
Thanks

I'm still a little new to the macro writing. a little more help please :)

"Sheeloo" wrote:

You need to write a macro which will check whether all answers are checked in
and if not then stay on sheet 1. Put this on a continue button.

In the second do the same for the End button

Also in the Worksheet_Activate() method of sheet 2, you need to check
whether sheet 1 is complete, if not then activate sheet1 again...

"SueQueen" wrote:

I have a form in Excel with questions. For the Answer Column C, the user
should answer with either "1" or "2" They are not to leave it blank. The
questions go from C10 to C37. I have a hyperlink at the bottom that links to
another worksheet. I do not want them to be able to continue until they have
filled in cell, answering all questions with either a "1" or "2" Once they
finish the 2nd worksheet, They click End. I again want them to have to
answer each question. I am under a deadline and would greatly appreciate
anyone who can help me with a solution.
Thanks