If then Statements & checked Boxes

Hi Guys , great forum you have here ...

Obligitory N00b post about how I am new to VB & am in need of assistance ...


I'm trying to create a macro that says if optionbutton1 & optionbutton2 are checeked then create a graph with this (xyz:xyz)range ... else if optionbutton1 & 3 are checked then create a graph with (abc:abc) range .... etc etc


so the good is that it does create the graph with the correct range(s) ...

the problem is that it does not just make the ones with the checked boxes with appropriate variable , it makes every combination of graph & I only want it to select the range that correspond with the checked boxes

so here is the code I have , hopefully its obvious what I have done wrong

Please Login or Register  to view this content.