Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Speed up your file

FastExcel
The best tool to optimise your Excel model!
Home > English site > Articles > Control Events > Preparations
Deze pagina in het Nederlands

Handling Worksheet control events using a class module.

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:


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.