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
Programming
C # for VBA Programmers
So you know VBA but for some unknow reason you need a cut to the case guide to understand C# quickly. First thing to understand is the VBA has both subroutines and functions, most other programming languages just have functions. In VBA the subtle difference between a subroutine and a function is … [Read more...] about C # for VBA Programmers
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
How to code a vba form without using global variables
Global variables ruin applications Here is how to code a form without using those dreaded globals.This is especially useful for forms that must appear in the middle of a running process, and that need to collect information from the user and then pass the user's choice back to the calling code and continue running. … [Read more...] about How to code a vba form without using global variables