The Strategy Pattern in VBA
Interchange deadly combat maneuvers dynamically, swapping out algorithms without disturbing the core entity.
✧ GANG OF FOUR LINEAGE & ARCANUM ✧
GOF DESIGN PATTERN: Strategy
ARCANUM SCHOOL: Evocation // Spreadsheet Necromancy
SCRIBE / ARCHON: Joshua Edward McLaughlin Cox
CANONICAL REGISTRATION:
// VBA PATTERN //
' Interface: IEvocationStrategy (Class Module)
Public Function CalculateDamage(baseMana As Double) As Double
End Function
' Class: HellfireStrategy (Class Module)
Implements IEvocationStrategy
Private Function IEvocationStrategy_CalculateDamage(baseMana As Double) As Double
' Massive burst, high variance
IEvocationStrategy_CalculateDamage = baseMana * 2.5
End Function
' Class: VoidDrainStrategy (Class Module)
Implements IEvocationStrategy
Private Function IEvocationStrategy_CalculateDamage(baseMana As Double) As Double
' Consistent, lower damage, ignores armor
IEvocationStrategy_CalculateDamage = baseMana + 50
End Function
' Class: WarlockContext (Class Module)
Private pStrategy As IEvocationStrategy
Public Sub SetStrategy(strat As IEvocationStrategy)
Set pStrategy = strat
End Sub
Public Sub ExecuteAttack(target As Range, baseMana As Double)
Dim dmg As Double
dmg = pStrategy.CalculateDamage(baseMana)
target.Value = target.Value - dmg
End Sub
' Client
Public Sub WarRitual()
Dim warlock As New WarlockContext
' Attack with Hellfire
warlock.SetStrategy New HellfireStrategy
warlock.ExecuteAttack Sheet1.Range("A1"), 100
' Switch tactics dynamically
warlock.SetStrategy New VoidDrainStrategy
warlock.ExecuteAttack Sheet1.Range("A1"), 100
End Sub
The Strategy: The Interchangeable Hex
When your macros require multiple variations of an algorithm—such as parsing different date formats, calculating various tax schemas, or applying distinct evocation damage types—hardcoding them with massive If statements binds your code into an unmanageable knot.
The Strategy pattern defines a family of algorithms, encapsulates each one into a separate class, and makes them interchangeable. The WarlockContext holds a reference to an IEvocationStrategy. At runtime, the spreadsheet necromancer can hot-swap the strategy, instantly changing the entity’s attack pattern without altering its core architecture.
Runic Tags:
#vba
#strategy
#behavioral
#spreadsheet-necromancy