A couple uses of a timer in Excel VBA are pausing code and measuring elapsed time. The following will take you to the respective place I’ve posted an example of each use:

1. Pause code execution for a desired amount of time with Application.Wait (simulating a timer)

link: Hide Excel

2. Measure elapsed time with a Timer in VBA

link: Benchmarking Code