Making independent groups of option buttons

Question

I am looking to make sort of a little form with groups of checkboxes and option buttons which will later feed a vba code. I need to make group boxes with 3 option boxes in them but independent. As it is now i press one of the options bokes and it inchecks an option box in the other group. They are all connected and i don't want this. Any Ideas? Thanks

Answer 1

A simple way to do is to set the GroupName property for the option buttons in the form. Set it to OB1 for first three option buttons and OB2 for the next three option buttons. Now they will work as two groups and you can check one each from eithr groups.