Thread: [Solved] Excel VBA - Assign Value to Option Button
View Single Post
 
Old 08-30-2016, 08:12 AM
janoshan janoshan is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Aug 2016
Posts: 1
janoshan is on a distinguished road
Default Excel VBA - Assign Value to Option Button
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!
Reply With Quote