Often OptionButton controls are arranged in
control arrays. To quickly find the index of
the only selected OptionButton control you
can use the following code:
Note that the first operand is always zero,Code:' assumes that the control array contains three OptionButton controls intSelected = Option(0).Value * 0 - Option(1).Value * 1 - Option(2).Value * 2
and you can simplify the above expression as follows:
intSelected = -Option(1).Value - Option(2).Value * 2




Reply With Quote