You want to start using macros or visual basic for applications in Excel, but you can't find the developer menu! You can watch the video above or follow along with the article below. Which ever works best for you. Don't worry, Microsoft in their wisdom, have disabled the Developer Ribbon by default.So to enable the developer ribbon in Excel follow along … [Read more...] about How To Enable The Developer Ribbon In Excel
Programming
VBA Class Module Example – Better VBA With Objects
How to use Class Modules in Excel VBA, check out the video tutorial then the article for some extra depth. Get VBA Class Module Spreadsheet Here Also get updates when new blog or video tutorials are released. Submitting... VBA Class Modules - Some … [Read more...] about VBA Class Module Example – Better VBA With Objects
How To Automate Tasks With Microsoft Excel VBA
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
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 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
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