Microsoft Visual Basic for Applications (VBA) enables non-programmers to record, create, and edit macros that can automate tasks in Office applications. This article explains where you can find help when you use the Visual Basic Editor provided in your Office application.
Access
-
On the Create tab, in the Macros & Code group, click Visual Basic.
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Access VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Access, expand the Access VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Excel
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Excel VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Excel, expand the Excel VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Outlook
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Outlook VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Outlook, expand the Outlook VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
PowerPoint
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used PowerPoint VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under PowerPoint, expand the PowerPoint VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Visio
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Visio VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Visio, expand the Visio VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Word
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Word VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Word, expand the Word VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Access
-
On the Database Tools tab, in the Macro group, click Visual Basic.
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Access VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Access, expand the Access VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Excel
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Excel VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Excel, expand the Excel VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Outlook
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Outlook VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Outlook, expand the Outlook VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
PowerPoint
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used PowerPoint VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under PowerPoint, expand the PowerPoint VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Visio
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Visio VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Visio, expand the Visio VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Word
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
If you haven't used Word VBA Help before, you will be asked to choose the browser in which you'd like help to be displayed.
-
In the browser, on the left pane, under Word, expand the Word VBA reference.
-
In the left pane, browse to find the concept, procedure, or object that you want help with, or type a query in the Search box at the top right corner of your screen.
Access
-
On the Database Tools tab, in the Macro group, click Visual Basic.
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
Excel
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
Outlook
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
PowerPoint
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
Visio
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
Word
-
On the Developer tab, click Visual Basic.
If you don't see the Developer tab:
-
Click File > Options.
-
Click Customize Ribbon, and then, under Main Tabs, select the Developer check box.
-
Click OK.
-
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic for Applications Help.
-
In the Search box, type the method, property, function, statement, or object that you want help with, or type a query.
Access
-
On the Database Tools tab, in the Macro group, click Visual Basic.
-
In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic Help.
-
In the Help window, click Access VBA Reference.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
Excel
-
On the Developer tab, click Visual Basic.
I don't see the Developer tab
-
Click the Microsoft Office Button , and then click Excel Options.
-
Click Popular, and then select the Show Developer tab in the Ribbon check box.
Note: The Ribbon is part of the Microsoft Office Fluent user interface
-
-
On the Help menu, click Microsoft Visual Basic Help.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
Outlook
-
On the Developer tab, click Visual Basic.
I don't see the Developer tab
-
On the Tools menu, click Options.
-
On the Other tab, click Advanced Options, and then select the Show Developer tab in the Ribbon check box.
-
-
On the Help menu, click Microsoft Visual Basic Help.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
PowerPoint
-
On the Developer tab, click Visual Basic.
I don't see the Developer tab
-
Click the Microsoft Office Button , and then click PowerPoint Options.
-
Click Popular, and then select the Show Developer tab in the Ribbon check box.
Note: The Ribbon is part of the Microsoft Office Fluent user interface
-
-
On the Help menu, click Microsoft Visual Basic Help.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
Visio
-
On the Help menu, click Developer Reference.
How do I run in developer mode?
-
On the Tools menu, click Options.
-
On the Advanced tab, under Advanced Options, select the Run in developer mode check box.
-
-
In the Help window, click Visual Basic for Applications Language Reference.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
Word
-
On the Developer tab, click Visual Basic.
I don't see the Developer tab
-
Click the Microsoft Office Button , and then click Word Options.
-
Click Popular, and then select the Show Developer tab in the Ribbon check box.
Note: The Ribbon is part of the Microsoft Office Fluent user interface
-
-
On the Help menu, click Microsoft Visual Basic Help.
-
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
No comments:
Post a Comment