All posts tagged "Good coding practices"
Object Oriented Programming Explained – High Level
Why do you need to understand object oriented programming ? If you don’t have a grasp of OOP, or at least a three thousand foot view of this subject. Then you will be at a disadvantage communicating...
- Posted November 25, 2013
VBA Programming Tutorial – Using Functions and Subroutines
So you have started to write vba code but you are not quite sure if you are doing it correctly, or if you are “on track” to write professional quality macros.Why even bother to write pro quality...
- Posted January 30, 2013
Data hiding is part of the process of removing complexity from programs. Any program in a business environment that does anything useful, can easily have 500 lines to 20 thousand lines of code. This means things can...
- Posted January 9, 2012
Power Excel vba secret, avoid using select
Power Excel vba secret, avoid using select I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet. Instead understand...
- Posted May 9, 2011