Returning an index value from a group of ActiveX Option Buttons
<p>Let me start off by stating that I am a medical student, not a programmer.  I have written a spreadsheet that will work as an exam with 50 questions.  Each question has 15 multiple choice answers for which I use ActiveX Option Buttons grouped to each question number.</p>

<p>I use Activex instead of Form Option Button because I dump raw data from an exam into a hidden area of the worksheet and each option button caption references a cell in the raw data to display a different answer choice.  This way I can easily create a new exam just by adding a table of questions and answer choices.  I don't see how to do this with form option button.</p>

<p>But the ActiveX option buttons can't seem to return an index value to a single cell.  So, I have written the following for each button:</p>

<pre><code>Sub OptionButton1_Click()
  Range("B21") = "A"
End Sub

Sub OptionButton2_Click()
  Range("B21") = "B"
End Sub

Sub OptionButton3_Click()
  Range("B21") = "C"
End Sub
</code></pre>

<p>... and so on.  Fifteen buttons per question.  Fifty questions.  My worksheet is terribly slow to load and crashes on slower computers all the time.  There has to be an easier way.  Any suggestions?  Ideally, I would like a small snippet of code that could return an index value from each group to a particular cell whenever any option button in that group is selected.  Any help would be greatly appreciated.</p>

<p>On the other hand... another piece of help that would basically get me there would be if someone could help me figure out how to change the caption of a form option button to reference a given cell.  That would ALSO solve my problem.</p>