davesexcel.com

Excel information

Workbook, Worksheet, Regular Modules

Untitled 1

There are three modules usually discussed.

  1. Regular Module
  2. Worksheet Module
  3. Workbook Module

1-On the Keyboard Press Alt & F11 to open the VBA Editor, Select Insert=> Module, this creates a regular module.

Regular Module

2-Right Click on the sheet tab and select View Code to open the Worksheet Module.

Worksheet Module

3-On the Keyboard Press Alt & F11 to open the VBA Editor, double click ThisWorkbook to open the Workbook Module.