Your First VBA Macro

Writing your first macro means creating a Sub procedure in a module, adding a line or two of code, and running it. The classic starting point is a message box that greets the user, followed by writing a value into a cell. This small exercise teaches the full development loop: write the code, run it, observe the result, and debug anything that goes wrong.

Before coding, enable the Developer tab via File > Options > Customize Ribbon, which exposes the Visual Basic, Macros, and Macro Security buttons. In the VBE, insert a standard module with Insert > Module; general macros belong in modules, not behind worksheets. Finally, save the workbook in the macro-enabled .xlsm format, or the code will be discarded when the file is closed.

A basic macro uses MsgBox "Hello, World!" to pop up a dialog, then Range("A1").Value = "Hello from VBA" to write text into a cell. You give the Sub a descriptive name such as SayHello and wrap the statements between Sub SayHello() and End Sub. This tiny program demonstrates interacting with both the user, through the message box, and the worksheet, through the cell.

You can run a macro by pressing F5 in the VBE, choosing it from the Macros dialog (Alt+F8), or assigning it to a button on the worksheet. To debug, step through line by line with F8, set breakpoints by clicking the grey margin or pressing F9, and inspect values by hovering over a variable or using Debug.Print in the Immediate window. When an error occurs, VBA shows a dialog offering to Debug or End.