Please help fast - creating pop ups

[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

 

[SLAnt]

you need to read up on the InputBox function and the Msgbox function in
Excel VBA. these should give you what you need.

Somethinglikeant

 

[mward77095]

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

 

[pdgood]

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")