c7015
06-05-2012, 10:58 AM
Hey Guys , I have a small issue ,
I have 6 check boxes confusingly named optionbutton1 -> optionbutton6
they are on a user form that when checked selects a range to be graphed....
this all works fine , but I want to write an if then statement that says if any 2 optionbuttons (1 to 6 only) are checked then
'do this code
end
but I don't want to go thru all the variables if I don't have to
is there a line of code that works to say if more then one check box is selected then ...
'do this code
end / thread
I have 6 check boxes confusingly named optionbutton1 -> optionbutton6
they are on a user form that when checked selects a range to be graphed....
this all works fine , but I want to write an if then statement that says if any 2 optionbuttons (1 to 6 only) are checked then
'do this code
end
but I don't want to go thru all the variables if I don't have to
is there a line of code that works to say if more then one check box is selected then ...
'do this code
end / thread