title: VBA Userform to save textbox.Value to excel worksheet when name is selected in combobox
body: <p>I apologize in advance for posting the same question, but I don't know how else to add additional code example.  If there is a way to add additional code to a previous question, please advise. Basically, I am trying to save some textbox values into my worksheet so they can be reinitiated when userform is closed and re-opened.  This is what I have thus far..but clearly its wrong!
  <br>
  <br>
  Basicaly, I have a combobox(procNamecombobox) that populates from column "A" on worksheet "DailyNumbers".  I just want the below textboxe.Values to save in the corresponding columns (B,C,D &amp; E) next to each name, when its selected in the combobox.</p>
  
  <pre><code>  Private Sub procNamecombobox_Change()    
  
    Dim ws As Worksheet
    Dim EmptyRow As Long
  
    Set ws = Sheets("DailyNumbers")
    EmptyRow = ws.Range("B" &amp; Rows.Count).End(xlUp).Row + 1
    ' *** Check combobox selection ***
    If procNamecombobox.ListIndex &gt; -1 Then
  
    ws.Range("B" &amp; EmptyRow).Value = completeCount.Text
    ws.Range("C" &amp; EmptyRow).Value = handledCount.Text
    ws.Range("D" &amp; EmptyRow).Value = wipCount.Text
    ws.Range("E" &amp; EmptyRow).Value = suspendCount.Text
    ws.Range("B2:B" &amp; EmptyRow).Sort key1:=ws.Range("A1:A" &amp; EmptyRow),  order1:=xlAscending, Header:=xlNo
    Else
   MsgBox "Please select your name"
   End If
  
    End Sub
  </code></pre>