vba for Option button to select

[saravanan1981]

I Have A userform Name "Product_Name"

There I have three option (In Option Button)
1. GPA, 2. GMC and 3. GTL

Also at down there are

two Button "Next" and "Back"

I want a code to select any one of the above 3 product before clicking on next. If anyone clicking on next without selecting it should show error "Please select your product). Without selecting it should not go to next level

[Olly]

Put your option buttons in a frame, so that only one can be selected at a time.

Then your 'Next' button code might look something like:

Please Login or Register  to view this content.

Example file attached.