title: Excel combobox listfillrange property pointing at a formula-based named range has issues
body: <p>ActiveX combobox objects in Excel do not behave well when their ListFillRange refers to a formula-based Named Range (Defined Name).</p>
  
  <p>I think I have encountered other errors and possibly even Excel crashes thanks to this, but right now all that happens is the combobox_change() event is triggered anytime ANY cell in the workbook is changed.</p>
  
  <p>I am not sure if this is really a bug, or if there is a fix, or a workaround.  If it is a bug, how do I report it to the Excel people?</p>
  
  <p>And finally, the real meat of my question is "How do I work around this issue best?"  I would like to have some formula-based named ranges, but it <em>seems</em> like this won't be possible.</p>
  
  <p>To reproduce this bug, do the following:</p>
  
  <ol>
  <li>Create a new workbook.  On Sheet3, create a small table 3 columns across, and several rows high.</li>
  <li>Create a named range with this formula (or an equivalent): =OFFSET(Sheet3!$A$2:$C$36,0,0,COUNTA(Sheet3!$A:$A),COUNTA(Sheet3!$4:$4)) To do this use Input>Name>Define.  Name the range something like "demoRange"</li>
  <li>Go to Sheet1 and create a combobox, (<em>it must be on a separate sheet</em>).  (Use the Control Toolbox menu, <em>not</em> the Forms menu).</li>
  <li>Click on the Design Mode button (the blue triangle with pencil), then right click on the  combo box and go to Properties.</li>
  <li>In the properties window for the combobox, change the ListFillRange property so that it points at the named range you created in step 2 ("demoRange").</li>
  <li>You may want to change the ColumnCount property to 3, and the ColumnWidths property to "50,50,50"</li>
  <li>Set the linkedCell property to cell "A1" by typing A1 in the linkedCell property.</li>
  <li>Close the properties window, and double click on the combobox to define its change() event.</li>
  <li>Put a Debug.Assert(false) or Msgbox("demo") line in the subroutine for the new combobox's change event.</li>
  <li>Exit design mode</li>
  <li><em>important</em> - Now select an item in the combobox.  The event should trigger normally the first time.  (The bug will not show if you don't do this step--something must be selected in the combobox)</li>
  <li>Edit cells anywhere in the workbook [Edit] or any other open workbook [/edit], on any sheet and any location.  Each time you edit any cell, (at least for me), the onchange event for the combo box is run.</li>
  </ol>
  
  <p>Again, is this normal, and what is the best alternative for what I am doing?  This combo box gets linked to various cells, and is supposed to be a replacement for the tiny font in the data validation dropdowns excel provides by default.</p>