I Indeed doubt if it is possible to create a worker thread in VBA. What I
have done before is fire events from a thread in an ActiveX control. In this
way you can e.g. open a form and run some background code on interval base.

You are right, not a true worker thread.

Marc




"jamieuk" wrote in message
om...
You can create a worker thread in VBA using APIs? I've only seen this
done using MFCs in C++. Please post some exmaple code.

--

"mb" wrote in message
...
Yes and No.
Yes: You can use the Win32 API to create a worker thread.

"Yohan" wrote in message
...

My question is:
Is there any way to tell Excel to run the macro in the background so
that
I can still work on my Excel file while Excel is doing the calculation?