macros run slowly with "ActiveX Button", but run faster with "Form Control Button"

[darigh]

I have a problem of macros running very slowly, with something very strange!

When I click on ActiveX Button1, it takes for instance 15 seconds to accomplish the following macro :

Please Login or Register  to view this content.

The behavior is the same when I run CommandButton1_click() from VBEditor by pressing [F5] key!



Instead, in the same sheet, I created a "Form Controls" Button that launches the same macro "CommandButton1_click" and now it takes only 2 seconds to run the macro...



That can be a solution for some of you to improve the execution speed of macros.


Unfortunately, We can't apply this method for all slow macro.

I'd like to find the cause and a solution of:

Why the same macro runs slowly when I click on a "ActiveX" Button (or [F5]) and runs faster when I click on "Form Controls" Button ? very wierd

[6StringJazzer]

Welcome to the Forum darigh!

This is not normal behavior. We cannot diagnose this without an example. Please see yellow banner at the top of the page and attach a sample file that has both buttons and displays the behavior you are describing, with actual code.

Also, can you tell us something about the platform you are running on? What version of Windows are you using? What is the CPU, and what is the physical memory size for your computer?

[darigh]

hello,
hereby a sample XLSM file that shows my problem of execution speed with "ActiveX Button" vs "Form Control Button"


timelipse ActiveX or FormControls.png


I checked on 3 different computers
Laptop HP ZBook i9 32GB Ram 1TB Nvme with W11 23H2 + Office 2019
Desktop HP Omen i9 64GB 2TB Nvme with W11 23H2 + Office 2019
Laptop Lenovo Carbon X1 i7 32GB 1TB Nvme W11 23H2 + Office 2021
...Same problem on each machine

Thank you for your Help

[6StringJazzer]

Both buttons took about the same amount of time. The Time function is not precise to more than 1 second but you can see these were within 1 second of each other. I modified the code slightly so I could include in the output which button was clicked, and to calculate the elapsed time.

So I am unable to reproduce your issue.

Please Login or Register  to view this content.

Please Login or Register  to view this content.