title: VBA custom add new values to Combobox
body: <p>My VBA code selects two categories based on a range that I have in a worksheet:</p>
  
  <pre><code>Private Sub Workbook_Open()
     Application.WindowState = xlMaximized
     Sheets(1).Activate
     MsgBox "Welcome to the Work Tracker " &amp; vbNewLine &amp; vbNewLine &amp; "Developed by ME"
  
     frmItemList.cmbCategory.List = Sheets("cmb").Range("A1:A2").Value
     frmItemList.cmbMonth.List = Sheets("cmb").Range("B1:B12").Value
     frmItemList.cmbDay.List = Sheets("cmb").Range("C1:C31").Value
     frmItemList.cmbYear.List = Sheets("cmb").Range("D1:D11").Value 
  End Sub
  </code></pre>
  
  <p>I want to take the combobox (cmbCategory) and have it that when people add their own categories, it adds to cell A3 and the range dynamically increases to include the next value. </p>
  
  <p>Thanks,</p>