Home Up Updates Add-ins Fun Stuff

Bill's Opening the VBE ...
 

 

Home
Up

 

 

 

Microsoft  PowerPoint MVP 2003-2007

 

    Opening the VBE (Visual Basic Editor) window is fairly easy since there are 2 methods to do so.  The VBE is where the Visual Basic for Application code is displayed and can be edited.  You will need access to this window to customize a macro or to write an add-in.  The actual VBE window will be shown a little further down the page.

    When you are given a macro, this is where you will add it into a module so you can run it from your presentation.

    The first method of opening the VBE window is to select Tools -> Macro ... Visual Basic Editor.  This will open the window with the active presentation selected.  Click on the image to the right to expand the image to show the selection process.

    The other method is a keyboard shortcut of the first.  Press and hold the Alt key (usually on either side of the space bar) while you press the F11 key once.

 

  

 

    Now that we are in the VBE, let's spend a minute looking over the various smaller windows and what each does.  The first one you need to know is the Project window that normally hangs out in the upper left corner.  I have several Add-ins active, so there are several listed here in the window.  The one we are interested in is the one that says VBAPoject(Presentation 1).  If there is no + next to it, as shown in the picture, then there is no Modules, UserForms or Classes assigned to it.  We'll want to change that.

 

 

If there is no +

 

If there is a +

 

Click on insert, then click on Module, and a new module will open in the large central window.

 

Click on the plus sign and it will show the attached VBA components.    Double click on a module to open that module in the main window.

    Now that you have an open module, you can type or paste a macro into the text area.

   

 

Home ] Up ]

Send mail to BillDilworth@mvps.org with questions or comments about this web site.
Copyright 2004-2007 Bill Dilworth
Last modified: 06/12/07