Make an optionbutton class

I'm working on an Excel 2016 workbook in which there are 10 worksheets each with a series of 4 x 10 option buttons.
Each worksheet is independent of the others and each set of 10 option buttons are independent of the other 30 option buttons.
Furthermore, each column of data is independent of the other 9 columns.

Excel with option buttons.jpg

I'm hoping for a way to reduce having to program each option button for each column, for each worksheet.
All I need to do when an option button in a column (the option buttons are grouped in each colunm) is selected is
run some code to show specific rows.

I was thinking about making an option button class, but could not find an example of such.

Do you think that would work? Do you have or know where an option button class example is located?

Thanks,
Jeff

Anyone have an Idea on how to fix this?

Finallly got this to work. Here's what I did. I made the class also parse the incoming button name.
Each of the four (groups of 10) buttons have either ST, EA,RR, or NS in their names.

Made a class called clsWSCtls

Please Login or Register  to view this content.

Then I made a standfard code module for each one of the buttons, as in modOptButtST. The standard module also handles the
differences in the set of 10 worksheets, In this case I'm working with the R1 worksheet:

Please Login or Register  to view this content.

Finally I put the following code in the Activate event of each workbook:

Please Login or Register  to view this content.

The reason I went with the class approach rather than using form buttons with a similar macro was that I couldn't figure out a way to bold the text of the form optionbuttons.