title: how to ask excel to "wait" for a cell's value to change?
body: <p>I'm calling a third party remote call to get data.
  after calling this function,datas will be filled from cells(1,1) to cells(10,1)
  my code is like this</p>
  
  <pre><code>application.caculation = xlmanual
  cells(1,1) = "some remotefunction"
  application.calculate
  while cells(10,1)&lt;&gt;"result"
  
  wend
  'if it goes here means we get the data
  deal_with_data
  </code></pre>
  
  <p>however,my code would hang in the while loop.
  so how to deal with this issue?</p>