All posts by Joseph Maabo

All About Comment Blocks in VBA

Introduction In programming, a comment is a statement that is used to explain a line of code or a whole procedure. Comments are not executed or compiled. They are also not mandatory, but it is a good practice to use them in your coding habits,

Windows System Error: splwow64.exe

Introduction If you have a 64-bit version of Windows 7, Windows Server 2008 R2 or Windows Server 2012 running on your computer, you might have had an issue with the Windows core system file called “splwow64.exe”. What is it exactly? Is it harmful to your

Drawing a Line Plot with Seaborn

Introduction A line plot is a graph that displays data using a number line. Many tools can be used to plot and visualize data. In this tutorial, you will do it with a powerful Python library for data visualization called Seaborn. Requirements For this tutorial, you

Drawing a Boxplot With Pandas

Introduction A Boxplot is a graphical representation of a data distribution in a dataset based on a five-number summary which are the minimum, maximum, median (50th percentile), first quartile (25th percentile) and third quartile (75th percentile). It was introduced by John Tukey in his classic IDE

A Guide to Commands in Visual Basic

What is a Command? A command is a specific instruction given to a computer application to perform a task or function. When referring to a programming language, a command is a unique word/keyword used to perform a specific operation. Unlike variables, which are named and

option explicit is automatically filled in

Everything About Option Explicit in VBA

As a developer, it is a good practice to declare your variables in a script/code so that you immediately get the source of an error when running it. Option Explicit is used in VBA precisely to make the defining of variables mandatory while writing code.

Vbcrlf: The Visual Basic Carriage Return Line Feed

To facilitate the reading of a messages by users or readers – especially long messages – it is necessary to format it conveniently through new lines, alignment, new paragraphs, etc. For a specialized word processing software like MS Word, this is easy. For example, to