How to assign a number to a cell in another sheet by clicking an object?

See the new attached file... it may fix your problems.

Now I try to answer to your questions:
1. In the previous file I used events to get modifications of option buttons. To see that macro you need to click right mouse on sheet label (for example 'sheet2') and select 'view code'.
2. I took the previous option button from the visual basic toolbar. To move that you need to click the square icon on visual basic toolbar
3. Visual basic option button can't have backcolor different from white.
4. Problem now fixed. I apologize for my distraction in the previous attached file.

I hope it can help.

Regards,
Antonio