Running macros simultaneously

[dlemos]

Hi all

Does anyone know if it's possible to run more than one macro at the same time?
For instance, if there are 3 functions.

FunctionA
FuncionB
FunctionC

Is it possible to run FunctionB and FunctionC WHILE FunctionA is being executed?FunctionA must end when FunctionC reaches its end.

thanks in advance

[shg]

No; VBA is single-threaded.

[dlemos]

Oh... =( ok then

That kinda stops me from doing what I wanted to do.

I wanted to run an animation while a certain code executed, kinda like a "loading screen".

I read that it is also possible to insert an animated gif into an excel worksheet. In this case, I would also need a macro to have an animated gif right?

[shg]

Sorry, no clue what you're trying to do.

[Deamo]

found something that may or may not be of help..

You could insert the Microsoft Web browser control (onto a userform for example) and set it to navigate to the location of an animated Gif, then show the userform at the beginning of the macro.. do the rest of your code.. then close the useform again

link was here: hxxp://en.kioskea.net/faq/1402-inserting-an-animated-gif-in-excel

[abousetta]

I have read something similar to what you want in the book by David and Raina Hawley entitled: EXCEL HACKS - 100 INDUSTRIAL STRENGTH TIPS & TOOLS. They call it 'display wait message' but in your case you could probably modify it to be a GIF image. You can download the example from here (chapte 7).

abousetta

[dlemos]

Thank you all for your replies.

I found an interesting site on how to work with the animated gifs.

http://www.xcelfiles.com/AnimatedGif.html

But I still can't get it to work with my specific code, I'll keep trying.