Sorry I misunderstood ur question.

I have a solution now, but little bit time consuming.
Create a 3sets of radio buttons (but radio button for forms, not active X)-
each set for one question. Put each set to the frame.
Each set (buttons in each set) assign to particular cell (right click on
button and choose format, last tab in format dialogue). Set 1 to one cell,
set 2 to second cell and set 3 to third cell.
Sum of this three auxiliary cells, if the form is filled correctly must be 6.
Through conditional formatting (for instance) give the respondent the
warning that questionnaire is not filled correctly (when the sum of three
aux. cells does not equal 6). It does not prevent from incorrectly filling
the form, but respndent at least would know that the form is filled
incorrectly.

"Tayo" wrote:

Hi Alojz,
Thanks for your response. Yes I know about what you are talking about (Data
Validation) but it won't solve the issue of entering same answer twice within
the 3 questions. What I mean is that somebody can now answer Agree in
qusetion 1 and answer Agree again in question 2. I don't want this. I want
to make sure that you can only select one type of answer once within the set
of 3 questions. I hope you understand my explanation.

"Alojz" wrote:

Here's my suggestion:
Do not have english version so do not know exactly the english names of menu
items.
Think it´s called data auditing, u can find it in data menu. Go to this
menu, set criteria to: allow list, to the source box type: agree, disagree,
indifferent.
U should be done. Or, create list somewhere vertically. Then assign ur
source list to source box. U need actually one column for answering the
questions.

"Tayo" wrote:

Dear All,

I am trying to set up a questionnaire with the following conditions:

There are 3 set of rows with different questions, each question can only
have one chosen answer out of 3 possible answers.


Possible Answers
Agree Indifferent
Disagree

Question 1:
Question 2:
Question 3:

Now the issue is that for the 3 questions, you can only select 1 agree, 1
disagree and 1 indifferent as answer. In other words, you can't have more
than 1 agree, 1 disagree and 1 indifferent in each of the 3 set of questions.
Please, what is the best way to go about this?

Here is a sample for further clarification:

Possible Answers
Agree Indifferent
Disagree

Question 1: Yes
Question 2:
Yes
Question 3: Yes