Excel VBA - Assign Value to Option Button

[janoshan]

Hello everyone,

I'm new to VBA and using option buttons and am trying to assign specific values to each option button that I have selected. For example: when I select the option "yes" I would like to have it display a score of 10 instead of 1, and "no" as a 0

Or Meets Expectations would be a "10" and Meets Most Expectations as an "8"

Is it possible to assign such values to option buttons?

Thanks!

[NoSparks]

Is it possible to assign such values to option buttons?

No, on a picture that isn't possible.

Hopefully you've Googled your thread title by now.
The first site Google returns for me is http://www.excel-easy.com/vba/exampl...n-buttons.html

janoshan, you're new to these forums, please take a little time to read and abide by the rules regarding cross posting. It will ultimately be to your advantage.

Cross Posted on at least 3 other forums.
http://www.excelguru.ca/forums/showt...-Option-Button
http://www.mrexcel.com/forum/excel-q...on-button.html
http://www.ozgrid.com/forum/showthread.php?t=200968