install VBA for excel

Question

I have excel and I need to be able to use VBA to program it. How do I install VBA to use with Excel?

Answer 1

VBA is installed as part of Excel/Office, but access to it and to VBA projects may need to be enabled.

To check that VBA is available and enable access to VBA projects in Excel on Windows:

1. Open Excel.
2. Select File > Options.
3. Select Trust Center, then Trust Center Settings.
4. Select Macro Settings.
5. Make sure Trust access to the VBA project object model is checked to enable access to Visual Basic projects.
6. Click OK to close the Trust Center, then OK again.

To open the Visual Basic Editor in Excel:

1. If the Developer tab is not visible:
   1. Go to File > Options.
   2. Select Customize Ribbon.
   3. Under Main Tabs, check Developer and click OK.
2. On the Developer tab, select Visual Basic to open the Visual Basic Editor.
3. In the Visual Basic Editor, use the Help menu and choose Microsoft Visual Basic for Applications Help for VBA documentation.

If VBA itself was not installed with Office (for example, in some customized installations of older Office versions), it can be added via Office setup:

1. Open Control Panel and run Add or Remove Programs or Programs and Features.
2. Select the Office installation in the installed programs list and choose Change.
3. Select Add or Remove Features, then Continue.
4. Select Choose advanced customization of applications, then Next.
5. Expand Office Shared Features.
6. Find Visual Basic for Applications, open its drop-down, and choose Run from My Computer.
7. Complete the setup and close the installer.

After this, restart Excel and use the Developer tab to access VBA.

---

References:

• Find Help on using the Visual Basic Editor
• Enable access to VBA to create or open a Visual Studio Tools for the Microsoft Office system project