Excel VB Macros

[Geeta SK]

I have two options buttons in my sheet1 in B2. I have named the first option button (Radio Button) as 'Yes' and second option button as 'No'. What I want to see happen is when a user selects 'Yes', Cell C2 should be populated with a value and if user selects 'No', Cell C2 should be populated with different value. If none of the option button is selected, no value should be populated in Cell C2.

Please give me vb script for this...