Check for OptionButton selection

[Nu2Java]

Hi,

I have 3 Frames in my userform which contain several optionbuttons in each frame. How can I be sure that in each of the 3 frames that atleast ONE selection has been made?

I have started with this code:

Please Login or Register  to view this content.

I'm not sure how this should be written to check for a selection in all 3 frames and then Exit Sub if not.

[Norie]

Try this.

Please Login or Register  to view this content.

[Nu2Java]

Thanks, Norie

This works perfect. How would I display the Frame name in there?

[Norie]

After Next opt add something like this.

Please Login or Register  to view this content.

That could show multiple message boxes, so you might want to use some other method.

For example you could build up a string and then display the message at the end.

[Nu2Java]

Excellent! Thank you Norie.... much appreciated!

[Nu2Java]

Norie,

One more little thing I came across... what part resets the current selections? If I make a selection in frame 1, 2 or both and not 3, I get the error message but then the first selections clear out. How to prevent that?

Please Login or Register  to view this content.

[Norie]

Not sure what you mean the code doesn't make any selections.

[Nu2Java]

What happens in my frames is... I select an optionbutton in Frame1, an optionbutton in Frame2 and then no selection in Frame3. I get my message box that says I need to make a selection in Frame3. When I click OK, the first selections are gone.

[Nu2Java]

Sorry, I figured it out. I needed to EXIT SUB after the msgbox. It was continuing with the code and resetting my selections.

[Norie]

There's nothing in the code that changes anything on the userform.

The code only checks the values of the option buttons.

Where have you put this code?

Is there any other code that could be causing the problem?

[Nu2Java]

Yes, hopefully you saw the last post. However, I have another curve ball. How can ignore all of this code if I have a single option button clicked in Frame 1 ? I will explain the best I can.... All 3 frames have defect selections.

Frame 1: Defect
Frame 2: Cause
Frame 3: Solution

So either in frame 1 or a single option button by itself that would be a "PASS" button which means everything passed and no selections needed.

[Norie]

Check that specific option button first.

Something like this perhaps.

Please Login or Register  to view this content.

[Nu2Java]

Thanks ... this helps a lot. Much appreciated!