Option Buttons

[alta77]

have a problem using Option buttons in Excel. The application has questions that the user has to select one of four option buttons as a answer to the question. The problem is that when the user move to the next question and choose one of the option buttons as a answer to the question the option button from the previous question is not checked any more. The check selection has move to where I clicked on the option button. What can I do to make the checked button stay checked while I select a other option button. I have found frame 2.0 as control that will do this for me. Is it compatible with windows 2000 and other applications or is there any other way. Thank you

 

[SkipVought]

Hi,

Each row of four option buttons must be grouped.

What kind of control are you using? FORM or Control Toolbox?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[HughLerwill]

The Option Buttons for each of your questions should be placed within a separate Container Control (frame) they will then behave as a group and their settings will not be changed by other groups; it sounds as if you may have discovered this yourself using your 'frame 2.0'. But why not just use the Frame Control in the Excel VBA ToolBox?