I’ve been playing with test driven development lately which has lead me into error handling in general and in vba specifically.
- Good Patterns For Error Handling
- Properly Error Handling in VBA (Excel)
- What Excel VBA actions are possible on hidden worksheets or workbooks?
- Error Handler – Exit Sub vs. End Sub
A very interesting thread on an access forum especially down thread where there is a discussion and sample code for a stack pop/push routine.
Why do we even care? Excel’s role in the London Whale debacle.