title: How do I programmatically double-click a cell in VBA/Excel?
body: <p>I have an Excel sheet with a formula that's only evaluated when the cell it's in is double-clicked. I have been trying to write some code in the open workbook event that triggers a double-click or VBA equivalent of a double-click to force an evaluation of this cell's formula but can't find anything that works.
  I've tried:</p>
  
  <pre><code>Application.Evaluate("I2")
  </code></pre>
  
  <p>^ Does nothing</p>
  
  <pre><code>With Range("I2")
              .Value = .Value
  End With
  </code></pre>
  
  <p>^Also does nothing</p>
  
  <pre><code>Dim doubleClick As Variant
  doubleClick = Application.WorksheetFunction.DfsCell("TimeSeries", 7.27, Chr(34) &amp; "IRESS_UPDATE!$B$5:$B$36" &amp; Chr(34), 2, , , , , , Chr(34) &amp; "IRESS_UPDATE!$A$2" &amp; Chr(34), Chr(34) &amp; "IRESS_UPDATE!$B$2" &amp; Chr(34), True, 0, False, True, "10:00:00", "16:00:00", 5, "0*5")
  </code></pre>
  
  <p>^Gives a Run-time error '438': Object doesn't support this property or method</p>
  
  <p>Does anyone know how to simulate a double-click on a cell?</p>