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 with software developers.Also the projects that you write yourself will be less effective and more difficult to write than they need be. If you aim to write some code in any … [Read more...] about Object Oriented Programming Explained – High Level
Good coding practices
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 code? Well mainly because it makes your job easier and you deliver a better quality product to your client for probably no more time invested than it takes to write a poor program. If … [Read more...] about VBA Programming Tutorial – Using Functions and Subroutines
Data Hiding
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 get complex real fast. Without using sound engineering principles most programs would become unmanageable. Data hiding is the term used for one of the … [Read more...] about Data Hiding
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 that the Microsoft Excel object model and your vba code will be more professional, robust and maintainable if you don't select anything but instead interact with the Excel objects directly. Check out … [Read more...] about Power Excel vba secret, avoid using select