VBA Program Flow.

[Blackbirdx61]

Hi,
I'm using an excel spread sheet to calculate possible bandwitdh values at work. NP there the formula works fine, but while the sub routine is running it locks out the computer.

I know there is a VBA Statement I can include in the Routine to release the focus temorarily so the computer would be able to check for other program events, but I've only used it once before, I cant remember it or find it online, or in my notes.

If anyone happens to know the Answer ... Its MUCH appreciated.

BB.

 

[RoryA]

I think DoEvents is what you are after.

 

[Blackbirdx61]

Yes,
Thats it thankyou very much.

Oh BTW, as a long time reader, first time poster. Let me thank you all for all the help and solutions I have found on this website over the last few years. Its an invaluable resource. Blessings, BB.