how to install Microsoft Visual Basic for Applications in office 365

Accepted answer

kguntaka 2,470 Reputation points Microsoft Vendor

2024-08-02T03:08:23.38+00:00
Hi Marcelo Suarez,

Thank you for reaching out to us on the Microsoft Q&A forum.

To install Microsoft Visual Basic for Applications (VBA) in Office 365, follow these steps:

Open the Office Installer:

Access your Control Panel and select “Programs and Features.”

Locate Microsoft Office in the list, select it, and click “Change.”

Modify the Installation:

In the Office installer, choose “Add or Remove Features.”

Find “Office Shared Features” and expand it.

Set “Visual Basic for Applications” to “Run from My Computer.”

Complete the Installation:

Click “Continue” and follow the prompts to finish the installation.

Refer following link: Install VBA.

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
Please sign in to rate this answer.
Marcelo Suarez 20 Reputation points

2024-08-02T17:47:14.0933333+00:00

When I choose the option to modify the installation of Office 365, I only get 2 options:

quick repair or online repair, but it does not let me choose the optional parts of the office installation that includes: visual basic for application.

Is there any way to create a custom XML type installation file to force you to install: visual basic for aplication? I searched, but did not find, could you give me an example of how it would be, please?

Marcelo Suarez 20 Reputation points

2024-08-02T17:47:32.7666667+00:00

When I choose the option to modify the installation of Office 365, I only get 2 options:

quick repair or online repair, but it does not let me choose the optional parts of the office installation that includes: visual basic for application.

Is there any way to create a custom XML type installation file to force you to install: visual basic for aplication? I searched, but did not find, could you give me an example of how it would be, please?

kguntaka 2,470 Reputation points Microsoft Vendor

2024-08-03T05:39:48.6033333+00:00

Hi Marcelo Suarez,

To access the optional components, you should try running the Office installation setup again, rather than using the repair options. Here's how you can do it:

Go to the Control Panel and select "Programs and Features" (in Windows 10/11) or "Add or Remove Programs" (in older Windows versions).

Find Microsoft Office 365 in the list of installed programs and select it.

Click the "Change" button.

In the "Change your installation" window, select "Modify" instead of "Repair".

You should now see a list of optional components, including Visual Basic for Applications. Check the box next to VBA to include it in your installation.

If you don’t see the Add or Remove Features option and only see Quick Repair and Online Repair, you may need to use the Office Deployment Tool or re-install Office with customization options.

If you're still having trouble, you can try running the Office Online Repair tool or the Microsoft Support and Recovery Assistant (SaRA) for further assistance.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

how to install Microsoft Visual Basic for Applications in office 365

0 additional answers

Your answer