View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
samela samela is offline
external usenet poster
 
Posts: 4
Default Changing the stated output of OptionButtons

I'm a complete Excel and VBA newbie and would like to know if it's
possible to change the output of OptionButtons from 'TRUE' or 'FALSE'
to "1"/"2"/"3"/etc..

The name of each button is:
Rating 1
Rating 2
Rating 3
Rating 4
and so forth..

The idea is for each rating to output its assigned number such that if
the user were to click "Rating 1", the result would be "1", "Rating 2"
= 2 and so on. I'm trying to design a survey and these results will
then be used to calculate an average rating.

Hope this makes sense,
Thanks.