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
All Articles
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
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
How to link images on a LibreOffice Base (Open Office) Form Dynamically
Let’s get images working on a LibreOffice (Open Office) base database form, in this tutorial I show you how to get this done without having to be a coding ninja. The idea for this tutorial came from a project that I'm hacking together, you see I'm aware that the navigation on this site could be better, so I'm creating a LibreOffice database that ties the content on my youtube … [Read more...] about How to link images on a LibreOffice Base (Open Office) Form Dynamically
How To Create a LibreOffice Database In Windows 10
There’s two ways to create a database in LibreOffice (similar to Open Office, but LibreOffice is updated and worked on more frequently). Create The Database You can create a database using either of the following methods. From the LibreOffice start screen, choose "Base Database". From any application within LibreOffice such as "Calc" or … [Read more...] about How To Create a LibreOffice Database In Windows 10