title: (Excel) Add items to Userform combo box
body: <p>I currently have an Excel spreadsheet which is created to gather my sales staff's time sheet for the day. There are a few things I'd like to do:</p>
  
  <ol>
  <li><p>I have created a Userform with the required details within the form, but the items in Combo box do not show. Here's the code for it    </p>
  
  <pre><code>Private Sub ComboBox1_Change()
  'combobox1_list
  .AddItem "PRA110AC"
  .AddItem "RAH111AC"
  .AddItem "RAJ112AC"
  .AddItem "MAL113AC"
  .AddItem "Extern"
  
  End Sub
  </code></pre></li>
  <li><p>I want this data to be pooled to another sheet within the same workbook under appropriate headers. I also want this to be a hidden sheet as this is confidential.</p></li>
  </ol>
  
  <p>I am new to this so I may have messed this up, but I guess I get a chance ;)</p>