Microsoft Office uses VBA as it's macro or programming language. If you'd like to learn to automate tasks with Excel VBA check out the video below and read this article. We'll give you an 80/20 overview of how to get coding vba macros for excel like an expert, enjoy... Lets get you coding fast, … [Read more...] about How To Automate Tasks With Microsoft Excel VBA
VBA
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
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