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

The answers would of course populate a spreadsheet.

How can I do this?


--
mward77095
------------------------------------------------------------------------
mward77095's Profile: http://www.excelforum.com/member.php...o&userid=34240
View this thread: http://www.excelforum.com/showthread...hreadid=539925

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

Somethinglikeant


--
SLAnt
------------------------------------------------------------------------
SLAnt's Profile: http://www.excelforum.com/member.php...o&userid=34184
View this thread: http://www.excelforum.com/showthread...hreadid=539925

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


--
mward77095
------------------------------------------------------------------------
mward77095's Profile: http://www.excelforum.com/member.php...o&userid=34240
View this thread: http://www.excelforum.com/showthread...hreadid=539925

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 the
answer should be in cell A2.
Then in Cell A2 create a Data validation table of several answers, one
of which is correct. In cell A3 enter a formula like: =IF((A2=correct
answer), "next question","Try Again").


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=539925