All posts by Joseph Maabo

How to Fix Compile Error: Expected: End of Statement

Introduction Every programming language has its own grammar and vocabulary — technically known as syntax. Having a mastery of any language implies that you have a sound knowledge of its syntax. As a beginner in VBA, you might be confronted with frustrating errors like the

How to Clear the Immediate Window

Introduction In a previous article titled “VBA print to console," you saw the use of the immediate window in VBA. You learned from that article that the VBA immediate window is a kind of playground where the VBA programmer can test code to see whether

VBA vs Python: Key Differences Plus a Dose of History

Introduction When beginning your coding career, you will certainly ask yourself questions like, “What exactly is a programming language?", “Which programming language should I learn", “What is the difference between language A and language B", etc. The answer to these questions and many others can

How to Use the Mod Operator in VBA

Introduction Mod stands for Modulo. It is a mathematical operator that returns the remainder, or modulus, of a number after performing division. The Mod operator is not only helpful when you want to know the remainder in division, it is also powerful when you want

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


Keep In Touch