Updates and Announcements
Worksheet Wrapper Classes
Recently published for VBA, an idea I developed to avoid using arrays while refactoring spaghetti code, uses a parameter class for the column values of a row, and then a class that would hold a collection of parameter (row) classes
, providing type ahead and methods to get values, as well as provide basic properties like Count and Item.
Preferred Documentation for Support
Currently producing documentation for a Office VBA project I recently refactored, I wanted to produce the most useful material for support.
The top of the results:
- Source Code
- Code Comments
- Data Models
- Requirements description
The link for the PDF is here
Phantom Debug Error Messages
Phantom debug error messages while coding VBA has always been a thorny problem, but I recently ran across a technique that seems to work. This is the quote of the person that presented it:
After some googling I've found better (quicker) solution: just end macro, switch to the VBE and hit Ctrl+Break. After that the code execution doesn't break.
As a series of steps:
- When the error message occurs, click Debug
- Press CTL+BRK
- Depending on the code location press F5