title: Excel VBA: how to store combo box current value to cell
body: <p>For a Login Form, I use the below code to store the values of all textbox and combo box controls in a separate sheet, the tags and text box values are populated, however the combo box values alone do not get written to cells. Can anyone point out my mistake?</p>
  
  <pre><code>For Each cControl In frmLogin.Controls
  If cControl.Name Like "txt*" Or cControl.Name Like "cb*" Then
      Sheet5.Cells(m, 10).Value = cControl.Tag
      Sheet5.Cells(m, 11).Value = cControl.Text
      m = m + 1
  End If
  </code></pre>
  
  <p>Next</p>