JKP Application Development Services.

                    Microsoft Office Application Development

Handling Worksheet control events using a class module.

Introduction 1 2 3 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:

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.

<<Previous        Next>>

    Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2007 JKP Application Development Services.