Option Buttons and If statement

In summery I have 2 sets of 2 option button groups, for example;

group 1 has:
Option_Button_A
and
Option_Button_B

Group 2 has:
Option_Button_C
and
Option_Button_D

Depending on which 2 buttons are selected I would like to run a different code. (4 in total)

I tried to use a code along the lines of;

Please Login or Register  to view this content.

However this does not seem to be working.

Could anybody help out??

Please Login or Register  to view this content.

YOur way is correct as long as you list all ways. there should be (4/(4-2)!/2!)=4x3/2=6 ways.

ab ac ad
bc bd
cd

not sure if

Please Login or Register  to view this content.

is correct

never mind. its correct

Thanks John the 'and' instead of the '&' did the trick.

Also its 4 ways, ab and cd are in the same set, so you cant select them both at the same time.

OK. didn't no. & isn't a procedure or object. it only works when working with a string such as in a message box

Make sense. I got the idea from the strings in msgbox. Thanks again

Try using the case statement to simplify your code

Please Login or Register  to view this content.

Interesting point mehmetcik, but would not be suitable for the particular project I am using.

Hi Leith,

the only reason why I didn't post my workbook is, I am working on a academic project. It would be against my university regulations to post the whole workbook.

Did my advice work?

Yup. thanks