Introducing the VBA Time Saver Kit – the kit that will save you time when developing in VBA. Want to save time when developing in VBA? Building the VBA Time Saver Kit I had in mind creating a collection of useful code snippets available from this site – aggregated in common code modules available easily […]
Idle time is often wasted time, however, sometimes you just need to wait for certain events to happen before you can continue code execution. VBA extends a couple of approaches to managing your idle time – the most popular approach is the Sleep procedure. The VBA Sleep procedure pauses code execution for a certain amount […]
As with most technologies Visual Basic for Applications (VBA), the scripting language available with most MS Office applications, is deemed by some to be already Walking Dead and soon to be deceased. VBA is a versatile and easy to use programming language allowing you to automate tasks and create simple MS Office applications. Visual Basic […]
One of the most common mistakes in VBA is using incorrect forms/dialogs for usually simple tasks. The VBA UserForm is one of the most exploited VBA modules I have ever seen (as opposed to VBA Class modules which are underutilized ;)). VBA developers and Excel users seem to think often that every dialog box and […]
The VBA InputBox is a very useful VBA user input feature along the VBA Message Box, before needing to reach out for VBA UserForms The InputBox allows you to create a simple pop-up message with a single user input textbox. A disclaimer to begin with: Refrain from using the InputBox for yes/no, binary questions, as […]