making a test paper
 

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

making a test paper
 

Explore data validation?

Select the range,
click Data Validation
Under Allow: List
Enter in Source: Yes, No
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spacemagnet" wrote:
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

making a test paper
 

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" wrote:

Explore data validation?

Select the range,
click Data Validation
Under Allow: List
Enter in Source: Yes, No
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spacemagnet" wrote:
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

making a test paper
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spacemagnet" wrote:
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?

making a test paper
 

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

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spacemagnet" wrote:
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?

making a test paper
 

Welcome, spacemagnet.

For more info on Data Validation,
try Debra Dalgleish's marvellous coverage at her:
http://www.contextures.com/xlDataVal01.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spacemagnet" wrote in message
...
Thanks Max i think I'm getting to grips with it now.