VBA Automation Tutorials

You can use Visual Basic for Applications (VBA) to automate repetitive tasks and add dynamic content to your presentations. One…

In this tutorial, we will explore how to utilize variables with the msgbox and inputbox functions to create dynamic dialog…

If you often find yourself converting Excel reports to PDF format and manually typing in the current date to keep…

In this short tutorial we will learn how you can use Visual Basic for Applications (VBA) to automate the saving…

In this tutorial we’ll learn how to use Visual Basic for Applications (VBA) to modify text size and style in…

Today’s Office automation tutorial is focused on learning how to verify that a file exists in one of your computer…

Today we’ll learn about how to easily check whether one or multiple cells are empty using Visual Basic for Applications….

Applies to: Microsoft Excel 365, 2021, 2019, 2016. In today’s VBA for Excel Automation tutorial we’ll learn about how we…

Excel 365, 2019, 2016. In today’s Excel automation tutorial we will learn how to quickly change the width of a…

Here’s a question from Danny: I have recently started using Microsoft Visio to make use of diagrams, layouts, and charts….

Going through the comments, i have seen a couple of reader questions on how to work with Visual Basic Input…

A couple days ago, a reader asked about there is a way to automate creation of PowerPoint presentations from scratch…

Applicable to Microsoft Office 365, 2019 and older. Windows operating Systems. Here’s a question we got from a reader: I…