Static declares a local variable that keeps its value between calls to the procedure, unlike Dim which resets each time.

Code

Static calls As Long
calls = calls + 1

• Call counter

  Static calls As Long calls = calls + 1 MsgBox calls → Counts how many times the procedure has run

  A per-procedure counter.

• Lazy initialization

  Static cache As Object If cache Is Nothing Then Set cache = CreateObject("Scripting.Dictionary") → Builds an expensive object once

  Caching.

• Whole procedure

  Static Sub Toggle() → Every local in the procedure is Static

  Rarely useful.

• Module-level variables achieve the same with wider visibility; Static keeps it private to the procedure.
• Values reset when the workbook closes or code is reset.
• Good for toggles and counters in event handlers.

• Easy to forget the value persists, which makes tests behave differently on second run.
• Reset by any edit to the code.