VBA - Timers

preview_player
Показать описание
Discussing how-to create and use Timers in VBA to evaluate the execution time of processes, the impact of design changes to make informed decisions when create/modifying VBA code, table, queries, forms, ...

Table of Contents:
00:00 - Introduction
00:13 - Opening Remarks
01:26 - Overview of the Database
02:05 - DateDiff
04:40 - TimeGetTime - winmm
06:28 - QueryPerformance - kernel32
09:24 - Demos
11:51 - Using the Class Module
12:23 - Comparing Record Counting Approaches
14:12 - Evaluating Table Design Changes
15:32 - Evaluating Query Performance
19:20 - The Importance of Multiple Tests
21:06 - Closing Remarks

Blog Article on the Subject:

My Links:
  1. D Pineault - Tech, Programming and more
  2. VBA
  3. VBA Execution Time
  4. VBA Timer
  5. VBA Process Time
  6. VBA Elapsed Time
Рекомендации по теме
Excel Simple Digital 0:14:29

Excel Simple Digital Clock Timer VBA Macro

Creating a Timer 0:06:11

Creating a Timer in Excel VBA that Changes Controls on a Userform

Excel Macro Timer 0:06:24

Excel Macro Timer - Easy to Use - Excel VBA Quickie 7

Timer in Excel 0:12:59

Timer in Excel VBA

How to Create 0:08:25

How to Create a Countdown Timer Clock in Excel and VBA

Excel VBA - 0:04:54

Excel VBA - Time loop

VBA - Timers 0:22:19

VBA - Timers

#8 - Run 0:09:09

#8 - Run Timer Start - Stop - Duration in Excel VBA | Learn Excel | MsOffice Learning | Excel VBA

How to insert 0:02:52

How to insert Countdown Timer in PowerPoint (Across Multiple Slides)

How to create 0:12:41

How to create a Countdown Timer in PowerPoint across Multiple Slides using VBA Macros - Tutorial

023. How to 0:06:15

023. How to use TIMER in VBA to run a MACRO at a Constant INTERVAL of TIME (and how to stop it)

VBA Macro: Macro 0:05:16

VBA Macro: Macro execution timer

How to make 0:07:33

How to make a countdown timer in powerpoint using VBA

Create a Digital 0:14:29

Create a Digital Clock Timer in Excel with VBA Macros | Step-by-Step Tutorial

Add a Timer 0:08:15

Add a Timer to Excel VBA

PDF To Excel 0:00:39

PDF To Excel Macro VB VBA Timer Control IBD Real time Stock Market Sensex Quotes Scraping

excel vba countdown 0:12:05

excel vba countdown timer

How to add 0:03:40

How to add a timer to your macro in VBA in excel

Excel VBA - 0:11:38

Excel VBA - Create a Timer on a UserForm (with 'Funnel')

Race Timer in 0:02:25

Race Timer in VBA

Excel VBA - 0:19:21

Excel VBA - Create Countdown Timer on UserForm

How to make 0:16:55

How to make your Excel VBA code run 1000 times faster

How to Create 0:15:48

How to Create Timer in Excel VBA - Excel VBA Tutorial

Millisecond Timer Excel 0:03:26

Millisecond Timer Excel VBA Compare Run Splits

Комментарии
Автор

Morning Daniel, this is a VERY informative video! I have watched MANY videos on how to evaluate query performance with timers, but none of them referred to the QueryPerfomanceCounter API you are using. I even learned a new way to clear the immediate window. Again, great video, thanks for taking the time to post it...

johnclark
Автор

Excellent work and presentation. The same goes for the many other topics on this channel. The QPC approach appears to be a cleaner version of Charles Williams' "Micro timer".

andrewtsegelsky
Автор

Hello This is very interesting. Is it possible to get a copy of your QPC code, please?

chrisbezant