This quick how to tip shows you how to add comments to your VBA code. Add comments to your VBA code VBA is short for Visual Basic for Applications. Overall, it is the coding language for Office apps. To make your code more readable, we suggest placing comments in your code. The image below illustrates […]
This lesson shows you how to assign a name to an object in Excel. When you work with objects in Excel, it helps to give them unique names. Especially, if you plan to use them in code. That is probably the main purpose for naming an object. Steps to assign a name to an object […]
This quick lesson shows you how to edit a basic macro in Excel. For the purpose of this lesson, we go through the steps on a PC running the Windows operating system. In addition, these steps should work perfectly in Excel 2007 or higher. Before we start, you need a macro to edit. We will […]
Fun with macros So, fun with macros is a set of learning tools that teach you to code and create great stuff in Excel. The basics Although we have a basics section, we do not plan to put our lessons in categories. Instead, when you learn to create code in Excel, you will realize, you […]
This tutorial shows you how to create a hello world macro in Excel. For the purpose of this lesson, we go through the steps on a PC running the Windows operating system. In addition, these steps should work perfectly in Excel 2007 or higher. A macro is a set of commands or actions that make […]
Macros are a set of commands or instructions to help you complete tasks that you may do often. Overall, it is a group of step-by-step instructions. Each task runs one after another. In addition, you can test and monitor your steps within the macro. In Excel, you can use the recorder to create a macro. […]
This tutorial shows you how to run a macro from a form button in Excel. If you do not have a macro to use, then create one. Or, just go through our Hello World lesson. In fact, we will use the macro from our Hello World lesson, in this tutorial. Steps to run a macro […]
This quick tip video shows you how to show or hide an object with a shape in Excel. For the purpose of this tip, we use Excel 2007 or higher, on a Windows PC. In addition, we use a mouse with left and right button functionality. Show or hide an object with a shape So, […]
This quick tip shows you how to show the immediate window in Visual Basic for Applications (or VBA) for Excel . Show the immediate window The immediate window allows you to test single lines of code. In most cases, you use Debug.Print to run single line commands in VBA. The video So, here is a […]
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Learn new things and improve on the skills you already have.
