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
All Articles
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 … [Read more...] about How To Enable The Developer Option In Excel
Simple LibreOffice Database Without Code
The following article will demonstrate how to build out a useful LibreOffice database without using any programming code. We're going to build a simple application to manage training courses and students for these courses. Get the database, files and sql used in the tutorial video above. Also get updates when new blog or video tutorials are … [Read more...] about Simple LibreOffice Database Without Code
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
LibreOffice Base Database Text Table Example
In this case study I demonstrate a practical example where Rainfall data is collected an analysed on an Australian Farm. The users system collects 288 data rows per day which totals to 104,916 per year, however he only wants the last row saved (which holds all the data for that day). In this tutorial I show you how to do this using a LibreOffice Split Database that uses the … [Read more...] about LibreOffice Base Database Text Table Example