Project Window

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi. I am just starting to learn VBA. I am going through
the book, "Writing Excel Macros" by Steven Roman.

I have opened the Visual Basic Project Window and only
see the following modules in the upper left Project
window:

+ Navigator (Navigator.xla)
- VBAProject (Book1)
- Microsoft Excel Objects
Sheet1
Sheet2
Sheet3
ThisWorkbook

The text book indicates that I should also see Forms and
Modules in this window. Does anyone know why these are
not present for me?

Thanks,
Mike.
 
Mike,

You will only see forms and modules if the workbook has such. In Excel, open
a new workbook, and select that workbook in the VB IDE, and goto menu
Insert>Modules or Insert>Userform, and then you will see some.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top