Hello,

I need to have a sub, which`ll be run every 5 seconds. How can I do it in
VBA?
I tried with :
while loop
+doEvents
+getMilis (from "kernel.dll")

but it makes 100% CPU usage and blocks Excel.
Is there any metod similar to threads (Timer) or sth. like this?

Thanks in advance!