Ref: Post #22 --

2. The Group Box and embedded OP have to be in one cell
It looks like you have the 4 OB's in different cells in 4 different rows


i have place a groupbox over the 4 Optionbuttons and nothing working for me.
Groupbox first, and then option buttons


Make the OB row taller, insert the form Group Box and then insert the 4 OB

Look at my attachment in 22


Capture.JPG

I did it that way so that all OB's have the same .TopLeftCell and therefore that same .Row wihich is where the result goes

Because I used .TopLeftCell when you insert rows above and things push down, you will get a new .TopLeftCell row, but the Range("A" & r) will be the row that the OB's are in