2 strategies:

store the value when a optionbutton is clicked; e.g. in the tag property of the userform:

Private Sub Optionbutton1_click()
  if optionbutton1 then tag=optionbutton1.caption
End sub

Cells(1,5)=tag
Or

- check the values of all linked optionbuttons

cells(1,5)= choose(ABS(1*Opt_1 + 2*Opt_2 +3*Opt_3 +4*Opt_4+5*Opt_5),Opt_01.caption,Opt_2.caption,Opt_3.caption,Opt_4.caption,Opt_5.caption)