Userform, multiple sets of ToggleButtons, rationalise to single code?

[poolierob]

Hello

I have a multipage userform which includes around 50 sets of 3 togglebuttons. Each set of 3 togglebuttons are within a frame and the frame includes a textbox and a label. The 3 toggle buttons are option answers to questions and the user must select one of the three togglebuttons for their answer of 'yes', 'no' or 'not applicable'. On selecting the correct button, the answer is placed into a specific cell on the worksheet.

I have the following code, which works fine for one set of the buttons:

Please Login or Register  to view this content.

Rather than repeat the code 50+ times, could someone point me in the right direction to be able to use the code once in a module (?) and then be able to call that module for each set of the 3 togglebuttons? It may be difficult as each answer is transferred into a non-consecutive cell in the workbook?

Thank you in advance for any pointers.

[JasperD]

Why don't you just call a separate piece of code for all and use that to do your stuff.

For example:

Please Login or Register  to view this content.

[buran]

Hi
The way to go when you want to manage large number of virtually the same controls (i.e. they do the same) with single piece of code is to create custom class. Attached is working example that should allow you to expand it as needed, as long as you follow naming conventions for frame and toggle buttons. the result is reflected in column A. In my opinion it's better to have OK button and reflect all changes at the end, but in this case I followed your style i.e. once toggle button is clicked, its value is reflected. And finally, it's better to use radio button controls instead of toggle buttons, as they take care to change the value for the rest of the controls in the group.
In my example I use consecutive cells to place the answer. You can use Array to store the values or you can put cell address in each frame's tag property at design time

[buran]

Actually,
here is example with non-consecutive target cells for answers
put worksheet name in Tag property of the UserForm
put each cell address as Tag property of the respective frame

[poolierob]

Thank you all for your replies, much appreciated

I'll try these options and report back !

Thanks

[poolierob]

Many thanks to JasperD and buran for your help.

All solutions worked, and I am going to use buran's non consecutive target cell method as it works best for the worksheet I have inherited.

Thanks again.