I was just reading another article by Charley Kyd over at ExcelUser (the guys with the sweet Excel Dashboard package for cheap!) on VBA standards for Excel "programmers." The article talked about providing documentation, and about using "Option Explicit".
While, I've been fairly meticulous about providng both "in-line documentation" (explanatory comments) and "title blocks" containing a general purpose statement for each macro, I especially appreciated the discussion on "Option Explicit" to remove the "variant by default" variable types. This is not something that I've routinely done, but will certainly endeavor to do from now on, as the benefits include enhanced processing performance and more easily identifiable errors.
While on the ExcelUser site, I also learned two other new things:
- For all of you stock-traders, you can get a free dashboard-style report for any company on the market.
- For all of you with your own Excel-related blogs or website, ExcelUser has a great Affiliate Marketing system. They'll pay you 30% on all sales you refer. I've signed up and have already referred 6 sales! Wow! Check it out.