title: vba application.ontime return function value
body: <p>I have the following code in my programme:</p>
  
  <p><code>Application.OnTime Now + TimeValue("00:00:1"), "sub1"</code></p>
  
  <p>which works perfectly to call <code>sub1</code> every one second. 
  But I want to use <code>Applicaiton.Ontime</code> to call a function <code>func</code> and return value to a variable.</p>
  
  <p>I have tried many alterations for the above code, none has worked. Any suggestions I can still use <code>Application.OnTime</code> to call a function or any other ways to do so?</p>
  
  <p>Thanks in advance!</p>