0
Thanks

A few words of thanks would be greatly appreciated.

VBA - Getting started with the Microsoft Visual Basic for Applications editor



This is a short introduction to the VBA editor and of its different components..
To access the VBA editor, simply press the keyboard shortcut ALT + F11 from any active sheet of your workbook.

The window at the top left (see picture above) lists all the modules in your workbook. You will find:
- Objects in your workbook, including the sheets, the ThisWorkbook object, the graphs etc..
- The standard modules,
- Class modules,
- UserForms.
Note: To insert one of these items in your project, simply click on the Insert menu.
The window at the bottom left (see picture above) lists the main properties of the selected object or module.
This window occupies the central position of the editor. It's there where you write your code.
Good luck in your projects ...
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « VBA - Getting started with the Microsoft Visual Basic for Applications editor », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments