What are custom events and why use them ? Custom Events Are Messages Custom events are messages that your program can broadcast to other objects in your application. They have the advantage of being massively flexible, because other objects can choose to react to or ignore these events depending on how you've programmed them. Custom events help simplify your … [Read more...] about How To Create Custom Excel VBA Events
VBA
How To Enable The Developer Option In Excel
In this quick tutorial I'll show you how to Enable the Developer Option In Microsoft Excel. Do you need the Developer Option Enabled? Firstly it's worth asking if you need the developer enabled for what you want to do? You don't need to have the "Developer" option enabled if you just want to get into the VBA Editor. If that's all you want to do, pressing the "Alt" key and … [Read more...] about How To Enable The Developer Option In Excel
Excel VBA MsgBox – Ultimate Tutorial
Msgbox allows you to communicate information to your user or request guidance on the next action that you'd like them to take. MsgBox can take up to 5 arguments, the message being the only one that's mandatory. Bear in mind that the message box is disruptive, meaning it halts processing until the user takes action such as pressing return or clicking … [Read more...] about Excel VBA MsgBox – Ultimate Tutorial
Understanding The Excel Advanced Filter
Background The Excel Advanced Filter gives you database like functionality and helps you crunch large datasets with ease it can also help you begin to better understand database structure. This article contains several tutorial videos related to the Advanced Filter, enjoy... Unlike the Autofilter which only allows you to filter on one element per column, the … [Read more...] about Understanding The Excel Advanced Filter
Excel Macro For Beginners, VBA Recorded Macro Tutorial
Article on its way, meanwhile, get the files that go with this video below... Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are released. Submitting... Wanna grab me a coffee? - Then Click … [Read more...] about Excel Macro For Beginners, VBA Recorded Macro Tutorial