VBA
Visual Basic for Applications (or VBA).
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 how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
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 […]
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 […]
Question on how to hide object in Excel with VBA What VBA line of code would you use to hide the named shpSaucer object in Excel? Select your answer below, and try not to take a sneak peak. A. Shapes.Range(“shpSaucer”).Show = False B. Shapes.Range(“shpSaucer”).Visible = msoFalse C. Shapes.Range(“shpSaucer”).Hide = msoTrue D. Shapes.Range(“shpSaucer”).Display = Visible Answer […]
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 […]