making a test paper

[spacemagnet]

How do i insert a yes/no facility that can be clicked on at the end of a
question? I've seen what I want in the templates but I can't modify to offer
multiple answers.
Thanks
Spacemagnet

 

[Max]

Explore data validation?

Select the range,
click Data > Validation
Under Allow: List
Enter in Source: Yes, No
Click OK

 

[spacemagnet]

Thanks Max, it worked just as you said. However, as soon as a click on
another box it disappears only coming back when I return to the box. How do I
keep it visable for all to see?

 

[Max]

One way is use an input message ..
Re-select the DV range, click Data > validation
Click on the Input Message tab
Under Input message, type say: Select response
Click OK

 

[spacemagnet]

Thanks Max i think I'm getting to grips with it now.

 

[Max]

Welcome, spacemagnet.

For more info on Data Validation,
try Debra Dalgleish's marvellous coverage at her:
http://www.contextures.com/xlDataVal01.html