Hi all,

I have searched the Google archives for an answer to this problem to
no avail:

Using XL2000 SP3 on NT4 SP6 and control toolbox controls:

When I have more than 3 option buttons grouped on a user form and
their control sources assigned to cells on a worksheet it takes two
clicks to change from one option to another. On the first click, all
options go false (along with the corresponding ControlSource cell
values). A second click will set the value of the clicked option to
true (along with its ControlSource cell value). I have been able to
replicate this on a very basic form:

-Insert a userform
-Drop 4 or more option buttons onto it
-Assign all of the options buttons the same group name
-Assign each option button's ControlSource property to a different
worksheet cell

show the form and click between options.

Any insight is appreciated.

Thanks,

-Will