Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project Window
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project Window
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 InsertModules or InsertUserform, 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) "Mike" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In the Project window where will be the double click option | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
How to activate (in the Project Explorer window) using VBA | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) |