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.