Excel selects the ribbon’s Home tab when you open it. Learn how to use the ribbon. Tabs The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review, View and Help. The Home tab contains the most frequently used…

In this tutorial we will learn how to use MsgBox in Excel 2022. The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program. Place a command button on your worksheet and add the following code lines: 1.…

In this tutorial we will learn how to protect an Excel Macro [guide] Just like you can password protect workbooks and worksheets, you can password protect a macro in Excel from being viewed (and executed). Place a command button on your worksheet and add the following…

In this tutorial we will learn how to Enable Macros in Excel 2022 [ guide]. Enable macros in Excel when the message bar appears. Change your macro security settings in the Trust Center. To create macros, turn on the Developer tab.…

In this tutorial we will learn how to use Option Explicit at the start of your Excel VBA code [guide] For example, place a command button on your worksheet and add the following code lines: Dim myVar As IntegermyVar = 10Range(“A1”).Value = mVar Result when you click the command…

In this guide we will learn how to add an Excel Macro to the Toolbar [guide] If you use an Excel macro frequently, you can add it to the Quick Access Toolbar. This way you can quickly access your macro. First, we record…

In this guide we will learn how to use FormulaR1C1 in Excel 2022 This example illustrates the difference between A1, R1C1 and R[1]C[1] style in Excel VBA. 1. Place a command button on your worksheet and add the following code line (A1 style): Range(“D4”).Formula = “=B3*10” Result: 2.…

In this guide we will learn how to use Relative References in Excel 2022. By default, Excel records macros in absolute mode. However, sometimes it is useful to record macros in relative mode. This program teaches you how to do this. If you…