| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Formulas - correctly stated | Excel Discussion (Misc queries) | |||
| Set of varibles produces one output. Need series of output. | Excel Programming | |||
| Matching cells (RE-STATED) | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| Excel 2003 prompts for the password when I am not opening the stated file. | Excel Programming | |||
Threaded Mode
