Recent Posts

What are Do While Loops and How to Use Them - VBA Tutorial

In VBA, a Do While loop is a type of loop that will continue to repeat a set of instructions until a specific condition is met. Contents:...

Naming your variables properly is an important, but often overlooking, building block that, once learned, will improve your codes...

Declaring variables is an essential part of programming in VBA. Declaring properly will help you avoid errors and improve the overall...

When creating macros and writing VBA, it is important to logically structure your code to maximize readability and ensure your code is as...

Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...

For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...

The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...

The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...

A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...

Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...

Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...