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,
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 ...
Published by deri58
Latest update on July 23, 2013 at 06:41 AM by deri58.