Excel OptionButtons

[Sam0101]

I have a workbook with multiple worksheets in it. It's basically a lengthy survey and on each worksheet, there are OptionButtons and CheckBoxes. As you go through the survey, you select the appropriate CheckBox or OptionButton that corresponds with your answer.

Here is my problem;

Sometimes when I flip from worksheet to worksheet, the OptionButton value is cleared. The CheckBoxes work just fine.

Any ideas? I've checked all of the properties and many many internet searches for help, with no success. There is no code under WorkSheet_Activate.

[RobDog888]

Welcome to the Forums.

Could you attach your xls file if possible? You have nothing anywhere that is setting the option button values?

[Sam0101]

The .xls file is huge (over 4MB in size). The only code effecting the option buttons is as follows (each OptionButton has similar code).

If OptionButton18.Value = True Then
Range("d10").Value = 0
Range("d11").Value = 3
Range("d12").Value = 0
Range("d13").Value = 0
Range("d14").Value = 0
Range("d15").Value = 0
End If

Yes, the OptionButtons "sets" are all in unique Groups (properties box).

Do you think Excel Service Pack 2 would effect it?

[RobDog888]

Not sure as I havent heard of this issue before. It may be a good idea to search MS for known issues on SP2 for office 2003.

One way to tell is to comment all your option button code completely and see if the issue goes away. If it does then its your code logic that is the problem.