title: Filling VBA userform's combobox with table column plus an additional option
body: <p>I am developing an application, in excel with VBA forms. in one form I have a combobox to that let user select customer name, the rowsource of this combobox is a named range (name column of customers table). Everything working fine but I need to add 1 or more additional items in the combobox that not exist in the table column. For example I need to add "All" item in the cobmobox so user can select a particular customer name or All. at other place I wan't to add "Other" item in combobox with same rowsource so if the customer is new user can select Other and then type name in textbox.</p>
  
  <p>I tried following code to add an item  </p>
  
  <pre><code>Private Sub UserForm_Activate()
  With Me.testCombo
  .AddItem "All"
  End With
  End Sub
  </code></pre>
  
  <p>but i got error 
  Run-time error '70'
  permission denied</p>
  
  <p>if i remove rowsource property from the combobox then the above code work but only one item "All" display.</p>
  
  <p>Note: I don't want to add "All" and "Other" in customer table, this could be easy solution but will cause other problem. </p>