Mouse Movement Freezes VBA Routine, and Screen Saver Causing Problems too

[rkaczano]

I am having issues with my VBA routine freezing at run time.

I have a very large dictionary (over a million keys) that is pulling down the performance of my routine. And I am noticing that if I move my mouse during the routine that I get the "Not Responding" message on my userform status bar. Sometimes it crashes the routine - sometimes not. But it is hit and miss. I am trying to stabilize the routine during runtime.

Also, when my screen saver comes on, this too can freeze my routine. I need to trigger a mouse movement or bypass the screen saver, altogether.

Any ideas on how to fix these two issues?

 

[mole999]

do you run any mouse enhancement software for gaming et al

 

[rkaczano]

no but it is a work laptop and there could be security software running in the background.

 

[rlv01]

Have you tried adding some DoEvents statements to your code to allow system events like a mouse movement to be handled?

 

[rkaczano]

No - I have not worked with those before. I will need to look into that.

 

[mole999]

what excel version are you using, what spec of PC and the OS