Userform with Checkboxes error

[Toadums]

ok, so i am making a sorta UFC pool thing. and so what i have is a userform with 5 tabs for each of the 5 fights. i have only started on the first tab and only the first 2 parts of it.

There are 3 parts to each tab. winner, via, round.

so i originally thought i would use radial buttons. first 2 will be for winner. second 3 will be either Submission, TKO or KO and then the other 5 for each round. but it turns out that you can only have ONE radial on per userform...so my first question is.

is there a way to make radials link to only 1 or 2 others. for example. for the main fight it will be dan henderson and anderson silva. so can i make it so that if dan henderson is selected, silva is de selected and vice versa. BUT if TKO is selected, silva can still be selected....not sure if this is making much sense...

anyways. so since radials didnt work, i thought i would use checkboxes. it was all going well, until all of a sudden it stopped filling in cell A2 when Anderson silva was selected (all the other 4 criteria's stll work FINE) what i mean by the other 4 criteria is that for example if Dan hendersons' box is selected, it puts dan henderson in cell A2 and if non are selected it erases all data in A2 and if both are selected, the msgbox comes up

so here is the code

Please Login or Register  to view this content.

Just ask for any clarification, or if you want to see the file

Thanks,

Paul

[shg]

If you're talking about Option ('radio') buttons, you can have as many as you want. Within a frame, only one may be True. So make frames for Winner, Via, and Round, and insert option buttons in each as appropriate.

[Toadums]

Ehh, sorry about saying radial.

But it worked!! thanks