title: How can I dynamically fill an Excel combobox with the content of a named table on a different sheet?
body: <p>on one Excel sheet I have a combobox.</p>
  
  <p>On another sheet, I have a table with a named column ("KontoNr") which should feed into the combobox. The table and column are named in the name manager and are shown as <code>=tabKontenplan</code> and <code>KontoNr =tabKontenplan[KontoNr]</code>.</p>
  
  <p>Now I am unsuccessfully trying to fill the comboxbox like this:</p>
  
  <pre><code>combobox.listfillrange = "=tabKontenplan![KontoNr]"
  </code></pre>
  
  <p>And</p>
  
  <pre><code>combobox.listfillrange = "=KontoNr"
  </code></pre>
  
  <p>also does not work.
  There ist no error, the combobox just remains empty... why is that?</p>