Friday, April 26, 2013

VBA Coding Style

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/bf247ff3-a496-400c-9bbe-d2477c6d33f6/

http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards

http://www.ee.columbia.edu/~marios/matlab/MatlabStyle1p5.pdf

http://www.exceluser.com/explore/vbastds.htm


Following consistent type and scope for the variables
Using inline comments where required

http://www.xoc.net/standards/rvbanc.asp

http://www.fincad.com/pdfs/vba_coding.pdf

good 2 page summary

http://en.wikipedia.org/wiki/Programming_style

http://en.wikipedia.org/wiki/Coding_conventions

Nothing on youtube

http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx

Talks about division: Naming convention, commenting and indenting.

For other rules please refer the coding standard reference (Primary):
(http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards) is a reference for VBA standards

VBA Coding Standards for reference only (Secondary):
1. http://www.exceluser.com/explore/vbastds.htm
2. http://www.xoc.net/standards/rvbanc.asp
3. http://www.fincad.com/pdfs/vba_coding.pdf
4. http://en.wikipedia.org/wiki/Programming_style
5. http://en.wikipedia.org/wiki/Coding_conventions
6. http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx


Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

No comments:

Post a Comment