Would you know of some methods or some tools to analyse the performance of a VBA Excel project?
I would like to measure the time spent in some functions or sub and to evaluate where it would be useful to improve the VBA code.
Would you know of some methods or some tools to analyse the performance of a VBA Excel project?
I would like to measure the time spent in some functions or sub and to evaluate where it would be useful to improve the VBA code.
Hello Lalbatros,
You can easily time the length of a Sub or Function by using this API macro. It counts in milliseconds. Place this code in a standard VBA module.
Macro Code
Next , you need to add 2 variables to your code routine to track the start and end times. Like this...Please Login or Register to view this content.
Sincerely,Please Login or Register to view this content.
Leith Ross
Try Aaron Blood's Time Trial tool here:
http://www.xl-logic.com/modules.php?...titleA&show=10
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks