title: VBA ComboBox Value by Index
body: <p>I've got a form that contains a combobox which contains the values </p>
  
  <pre><code>With io6
     .AddItem "90°"
     .AddItem "180°"
     .AddItem "270°"
     .AddItem "360°"
  End With
  </code></pre>
  
  <p>The member of this method I am actually using is .ListIndex.  When a user selects 270 degrees, I am sending a 2 to a variable.  When I read the variable, I want have the combobox correctly show the appropriate value.  In other words, if the variable is 1, I want the combo box to show 180 degrees.  Is that achievable <em>without</em> a select\if statement that writes into .Value?</p>
  
  <pre><code>Sub varChange(val as integer)
  
     With comboBox
  
       Select Case val
         Case 1
           .value = "90°"
         Case 2
           .value = "180°"
         Case 3
           .value = "270°"
         Case 4
           .value = "360°"
       End Select
  
      End With
  
  End Sub
  </code></pre>
  
  <p>The most direct I can ask this question is, can the method element be set based on the index?  Can I set the combo box element based on the index rather than having to write in a new value?</p>