| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make VBA wait for return from external function
Harald Staff wrote:
"Gib Bogle" wrote in message ... To be honest this is not my problem. A poster asked this question on a Fortran forum, and my curiosity was provoked. The poster says that "...Excel 2007 VBA skips over calls [to his Fortran DLL] that take any time to execute. If I go into debug mode for the VBA and pause after the call the code completes and the results are passed into Excel." If it works stepping and pausing through, a simple DoEvents usually does the trick when you want to wait for a calculation or similar. (Not including full loading of webpages and such demanding tasks) X = MyBogusFunction(y) DoEvents Range("A1").Value = X HTH. Best wishes Harald Thanks, I'll pass that advice on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 60 Second Countdown NOT using the WAIT function... | Excel Programming | |||
| wait function | Excel Programming | |||
| Make onTimer wait until Excel finish database request? | Excel Programming | |||
| How do I make the true return a drop down list in the IF function? | Excel Worksheet Functions | |||
| Web Query Sleep or Wait for return values | Excel Programming | |||
Threaded Mode
