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 sheet).

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 sheet within the same file?



So, for example, sheet 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.