Excel Background Function

[asibin2000]

I have a function in excel that looks up several databases and calculates a result based on a number of business rules.

Due to reasons beyond my control, the lookup function takes about 30 - 70 seconds to complete without a problem.

So my question is does anyone have some experience or links to making a VBA function multi thread so that the user doesn't have the pause while the function is working?

For example:

Cell "A2" would be a formula that equals =CustomFunction1(<CustID>)

This would return the customer name in Cell "A2" but takes a brief few seconds.

I want to limit the length of the pause or be able to have a function process in the background while the user continues to work in the sheet.

Any help or guidance would be greatly appreciated.

Asi

 

[SkipVought]

Hi,

You may be able to make your SQL or process more efficient. Please post your code. MS Query does have a BackgroundRefresh property. What query method are you using?

However, when it comes to spreadsheet functions, as it seems you are running, the clock during calculation is SOP. I'm not really sure that you can get around that.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]