I have a spreadsheet with the numbers 1-100 in column A. Column B
contains exam questions in rows 1-100. I would like to create a user
form that will display the questions one at a time to my students and
allow them to enter an answer selection (A, B, C, or D). That answer
will be stored on another tab for scoring. I would also like the
studentgs to be able to navigate forward and backwards (in case they
want to go back and change an answer to a previously answered
question). I know this has to be simple, but I'm having trouble
getting started. I've created other applications using Excel. I'm
not sure if a user form is the way to go or not. Could someone
please
point me in the right direction to get started? I would really
appreciate it. Thanks.

Hi,

I know you asked for the answers on a different sheet but first you should
look at this:

Put your cursor in the data and choose Data, Form. This gives you the
flexibiity you want without any need to program.

To take care of the issue of putting the answers on a different sheet, you
could put them, as another column in the data area, then you could format
them with a custom format of ;;; which hides the cell contents from
displaying in the cell. (There is also a way to hide the cell contents from
displaying on the formula bar.) Finally, you could set up formulas that
refer to the answer cells discussed above on another sheet.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Connie" wrote:

I have a spreadsheet with the numbers 1-100 in column A. Column B
contains exam questions in rows 1-100. I would like to create a user
form that will display the questions one at a time to my students and
allow them to enter an answer selection (A, B, C, or D). That answer
will be stored on another tab for scoring. I would also like the
studentgs to be able to navigate forward and backwards (in case they
want to go back and change an answer to a previously answered
question). I know this has to be simple, but I'm having trouble
getting started. I've created other applications using Excel. I'm
not sure if a user form is the way to go or not. Could someone
please
point me in the right direction to get started? I would really
appreciate it. Thanks.