Handling Worksheet control events using a class module

Pages in this article

  1. Preparations
  2. Class Module
  3. Hooking up
  4. Conclusion

Setting up the worksheet

I devised a worksheet that has two sets of option buttons, each set having their own Groupname (Set01 and Set02 respectively) to make them work as two separate groups of buttons:

 12 option buttons on an Excel sheet
Figure 1: Option button controls from the control toolbox on a worksheet

The idea here is to ensure that the currently selected option button will become red and the not selected option buttons will become green. Also I'd like to get feedback on which option button has been selected.