Macro fast when F5 from VBE but 5x slower with form button, activeX button, shortcut key and macro dialogue box, why?

[JZG]

The title says it all. This is not about tips to make my code run faster. I routinely run a "Turn Stuff Off" before and a "Turn Stuff On" after the main code.

The question is: When I run the same code from F5 in the VBE vs All Ways to CALL the code, why are all the other ways 5 times slower?

F5 = 5 sec
vs
form button = 26 sec
activeX = 26 sec
ctrl + sft + Q = 26 sec
selecting macro from the macro dialog box = 26 flipping sec

 

[Yongle]

1. post the code for us to look at

2. F5 ??- this simply opens the GoTo dialog box for me

 

[Yongle]

2. F5 ??- this simply opens the GoTo dialog box for me

ah - I missed the VBE bit

Post the code for us to look at

 

[JZG]

Sorry Yongle but I'm under a strict NDA and can't post the code. Regardless of the code though, is there an overhead issue with using a keyboard shortcut, et al vs. F5 from the VBE. Incidentally, the "Run Sub" play button in the VBE performs the same as F5.

 

[Yongle]

I have never noticed that problem
- but that does not mean that there is not a difference in performance.
I will do some testing and see if I can make it happen. I will update the thread with my observations tomorrow.

 

[JZG]

many thanks again. I've spent a fair amount of time searching for a thread. Shutting down all other office products and reboots have not changed anything.

 

[Fluff]

Not something I've ever noticed, but are you using two monitors?

 

[JZG]

I am using 2 monitors...

 

[Fluff]

That might be the cause, I have seen posts in the past where having the VB editor on one monitor & the sheet on another effects the code.

 

[JZG]

Fluff, One of the variations I've checked is with the editor open vs closed.