Using ToggleButtons to answer questions.

Hi,
I need the ability to select answers to multiple questions on a UserForm and then transfer the answers to a table.

Example

Q1 Are apples green. Yes/No
Q2 Is the sky blue. Yes/No
Q3 Can frogs jump. Yes/No/Maybe

An so on.

I was trying to use ToggleButtons. One for Yes, one for no and one for other for each question but had to right code for each combination of possible answers.

As you can see from the below code. And this is with just two questions.

Please Login or Register  to view this content.

Is there a more tidy way to achieve this. Ideally i would like to keep the ToggleButtons as i can have them any size.

Also i'd like to avoid being able to select more the one answer to each question.

Thanks for the help,

Sorry i should have pointed out that this is a small part of a much larger project. The table is just part of a larger table, half shows that a job has been raised the other half (that i have included in this post) includes the data when the job has been completed. I need to retain the ability for the user to select a started job from the table and update what they did. So looking for the next blank row will not work.