listi.net

Project Window

Microsoft Excel Objects - sheets
Forms
Modules
Classes

Show the Project Explorer CTRL R

or VBA > View > Project Explorer

What is the Project Explorer?

It's a tree structure of the sheets, forms, modules, and classes in the Spreadsheet.

What do you do with the Project Explorer?

Go to an object (sheet, module, form, class)

Insert a new object (Module, form, class)

Import or export an object

Remove an object

View code

Hide/show things

Modules

This is a way of organizing your code

You can load shared code into the project

Unfortunately, it's not really shared as it's a copy

Example Modules

Array_code
Alarm_code
Button_code
Automation_routines
Encryption_routines
FileRoutines
Formatting
Goto
Interenet
Jira
Outlook