RE: Help with questionnaire responses

Hi Gemz

Each radio button, checkbox, and text box has a 'linked cell' property - you
can set it to whichever cell is necessary (on any ***).

Right click on the checkbox, click on Format Control, from the Control tab
select the cell you want the control to link to.

Checkboxes return a TRUE or FALSE value, Radio buttons return a numeric
value, and textboxes return the text itself.

HTH

Trevor Williams


"Gemz" wrote:

Hi,



I was wondering if you could help me, i have a questionnaire which uses
radio buttons, check boxes and text boxes to record responses from users.



Is there a way (with some code) that i can record the response to each
question in another *** within the same file?



So, for example, *** 2 could have the responses - column A would be called
questions and column B would be called answers.



I would just do a simple lookup to do this but i dont think its going to
work with radio buttons and check box responses, not sure if a lookup can
lookup responses recorded in checkboxes and tickboxes.



Please reply at your earliest possible convinience.
Thanks.

.