ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA (https://www.excelbanter.com/excel-programming/354403-vba.html)

[email protected]

VBA
 
Hi all

I'm taking my 1st step in learning Excel VBA and I'm confused between
the following :

1. Workbook
2. Project
3. Module

Is it true that one workbook can only hold one project and one project
can have many modules? Your advice most appreciated. Thanks

Best Regards


Dave Peterson

VBA
 
Yep.

You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


wrote:

Hi all

I'm taking my 1st step in learning Excel VBA and I'm confused between
the following :

1. Workbook
2. Project
3. Module

Is it true that one workbook can only hold one project and one project
can have many modules? Your advice most appreciated. Thanks

Best Regards


--

Dave Peterson

Chip Pearson

VBA
 
You are correct. A workbook contains a single project, and that
project may contain any number of modules, forms, and class
modules.

wrote in message
oups.com...
Hi all

I'm taking my 1st step in learning Excel VBA and I'm confused
between
the following :

1. Workbook
2. Project
3. Module

Is it true that one workbook can only hold one project and one
project
can have many modules? Your advice most appreciated. Thanks

Best Regards





All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com