To input VBA code in Excel, follow these steps:
- Open Excel and go to the Developer tab. If the Developer tab is not visible, you will need to enable it first. Go to File > Options > Customize Ribbon. Under the Main Tabs section, check the Developer box and click OK.
- Click on the Visual Basic button in the Code group. This will open the Visual Basic for Applications (VBA) Editor.
- In the VBA Editor, you can create a new module or work with existing modules. To create a new module, go to Insert > Module.
- In the module, you can write your VBA code. For example, let’s say you want to create a simple macro that displays a message box with the current date:
Sub DisplayDate()
MsgBox "Today's date is: " & Date
End Sub
- Once you have written the code, you can run it by pressing F5 or by going to Run > Run Sub/UserForm.
- You can also assign the macro to a button or a keyboard shortcut for easier access. To do this, right-click on the button or go to File > Options > Customize Ribbon and assign the macro to a custom tab.