Create shapes and change their color, shape with PowerPoint VBA
You can use Visual Basic for Applications (VBA) to automate repetitive tasks and add dynamic content to your presentations. One…
How to Use Variables in VBA MsgBox and InputBox in Excel and Word?
In this tutorial, we will explore how to utilize variables with the msgbox and inputbox functions to create dynamic dialog…
How to Save Excel sheets as PDF with Current Date Using VBA?
If you often find yourself converting Excel reports to PDF format and manually typing in the current date to keep…
How to save Excel file with specific name and current date with VBA?
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…
How to check if a file or folder exists in your computer with Excel VBA?
Today’s Office automation tutorial is focused on learning how to verify that a file exists in one of your computer…
How to check if a cell or a range of multiple cells is empty with Excel VBA?
Today we’ll learn about how to easily check whether one or multiple cells are empty using Visual Basic for Applications….
How to set an Excel cell color according to a condition with VBA?
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…
How to create and add slides to PowerPoint presentations with VBA?
A couple days ago, a reader asked about there is a way to automate creation of PowerPoint presentations from scratch…
How to display the developer tab in Excel, Outlook and Word 2019 / 365?
Here’s a question we got from a reader: I am trying to figure out macro development from going through code…
PowerPoint Macros: How to run VBA in your PowerPoint 2016 and 2019 slides?
Applicable to Microsoft Office 365, 2019 and older. Windows operating Systems. Here’s a question we got from a reader: I…