Form Control OptionButtons Calculation

[MissOctober]

---

I have ms 2010
i have 4 form control optionbuttons with a group. i want the value (result to go the right) where it says score.

i dont have a vba code or anything but this image.

i'm such a noob and i just need some help.

everytime a button is click it should show up in the row where score = is

for example if button 1 is selected it should say score =10
i inserted a pic
http://[IMG]http://i65.tinypic.com/t5gdib.png[/IMG]

Thanks for any help

 

[VBALearner]

Assuming the cell where "Score=0" is cell C1, and the cell where 10 currently appears is cell A2, enter in C1:

="Score = "&A2

Hope that helps.

 

[MissOctober]

its not working

 

[Haluk_]

What do you expect to get as a result if you choose 1, 2 and 3 ?

.

 

[MissOctober]

1 = 10
2 = 20
3= 30
0 = 0

 

[Haluk_]

You check the file given in the link below;

https://drive.google.com/open?id=1bydtK3RRcnM9VPxK06SplsrbXdyLNj0T

As a summary; the Option Buttons are linked to the cell P3 and there is a small formula in cell K3 where the score is being displayed.

.

 

[MissOctober]

its not showing any optionbuttons in P3

 

[Haluk_]

Did you download the file itself ?

.

 

[Haluk_]

 

[MissOctober]

oh my bad. i got it to download. how did u managed to get the cells link to optionbuttons. thats what im stuck on