Run the Macro Open the Excel 2010 spreadsheet that holds your VBA code. Click the "Developer" tab at the top of the screen.

Open an Excel workbook on your PC. Press the Alt + F11 (or Option + F11 for Mac) keys to open VBA. Alternatively, you can head to the Developer tab and select Visual Basic.

Split your screen and watch the cells update as you step through the code. Running the VBA procedure To enter the procedure, press Alt + F11 to open the Visual Basic Editor (VBE).

Launch Excel and open a spreadsheet. Click the ribbon's "Developer" tab. Click "Visual Basic" to view the VBA editor. This editor opens in a separate window.