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.
Is there a more tidy way to achieve this. Ideally i would like to keep the ToggleButtons as i can have them any size.![]()
Please Login or Register to view this content.
Also i'd like to avoid being able to select more the one answer to each question.
Bookmarks