Please help fast - creating pop ups

  • Thread starter Thread starter mward77095
  • Start date Start date
M

mward77095

I need to create a questionnaire in Excel with questions that pop u
along with a data entry field for the participants answer. After th
question is answered, the next question pops up, and so on....

The answers would of course populate a spreadsheet.

How can I do this
 
you need to read up on the InputBox function and the Msgbox function in
Excel VBA. these should give you what you need.

Somethinglikeant
 
I'm really having a difficult time with this. I can't find info on the
things that you suggested. Any other help is really appreciated.

Thanks,
Mark
 
I'm not an Excel guru, but here is one way you could do it.
Example: In cell A1 place the first question and indicate that th
answer should be in cell A2.
Then in Cell A2 create a Data validation table of several answers, on
of which is correct. In cell A3 enter a formula like: =IF((A2=correc
answer), "next question","Try Again")
 
Back
Top