Within the Project window, right click on the object that you want to add the module to.To create a new Userform, Module or Class Module: You can also add additional Userform, Module and Class Module objects into the project (in the above image, a Module (named Module1) has been added to the VBA project for Book1.xlsm). Worksheet objects, linked to each worksheet of the workbook.A Workbook object, linked to the Excel workbook.This window provides you with a VBA 'Project' for each currently open Excel Workbook.Ī VBA 'Project' is a collection of all the VBA objects and modules that are linked to the current workbook, and will initially consist of: ![]() The Project Window opens up on the left of the VBA Editor (as shown in the above image).
0 Comments
Leave a Reply. |