title: I want to change the value of an option button in a user form via its name in a cell in Excel
body: <p>I have some option buttons set up such as stp1, stp2, stp3, etc.
  I have something that which is active into a cell, I want to be able to re-activate the option button via its name which is placed in the cell B6.</p>
  
  <p>I tried many thing here is an example:</p>
  
  <pre><code>Worksheets("Data").Select
  [B6].Value = oSel 'Option button select
  oSel.Value = True 'as to re-activate the option button
  </code></pre>
  
  <p>I recieved the name by using:</p>
  
  <pre><code>For Each Control In Me.Controls
      If InStr(Control.Name, "stp") Then
          If Control.GroupName = "Beginning" Then
              If Control.Value = True Then
                  oSel = Control.Name
                  Exit For
              End If
          End If
      End If
  Next
  </code></pre>
  
  <p>If you could help I would really appreciate it, and if I forgot some important information or you just need more... just ask. I am fairly new to VBA and I am experimenting.</p>