visual basic for applications download formulas ppt

VISUAL BASIC FOR APPLICATIONS DOWNLOAD FORMULAS PPT CODE

VISUAL BASIC FOR APPLICATIONS DOWNLOAD FORMULAS PPT CODE

You could have typed the above code directly into the code window if you were familiar with VBA code.īeing able to write macros directly into the code window will take some practice but the Macro Recorder is the best place to start if you want to learn more about the code. It is very easy to write a macro that works, but it requires a lot of practice to write a macro that is efficient. Both the above macros will only take a split second to run so you will probably not even notice a difference.įor larger, more complicated macros, speed becomes more of an issue.

Sub InsertingSlide()Ī('Rectangle 2'). = 'Another Slide'įor small macros speed is not that important. This macro has the slideindex hard typed to '2' so any new slides which you insert using this macro will be inserted as slide number 2. The following macro performs exactly the same action as the macro that was recorded, although this macro is significantly more efficient and will therefore run a lot faster. These are the lines that start with a ' ' ' and are displayed in green in the Visual Basic Editor. The first thing to remove is the comments. The above macro could be simplified significantly and the result would be exactly the same. The Macro Recorder will always include some line lines of code that can be removed. A new slide will be inserted with the same title. ' Macro recorded #date# by Russell ProctorĪ Index:=(Index:=2, Layout:=ppLayoutText).SlideIndexĪ('Rectangle 2').SelectĪ.TextRange.SelectĪ.TextRange.Characters(Start:=1, Length:=0).Select Notice that the default description is placed as a comment at the top of the macro.

Using this method will locate the macro for you and will display the code module where the macro can be found.Īnother application window should open and you should see the following lines of code. This will open the Visual Basic Editor in another window. Select the name of the macro and press the 'Edit' button. You can edit a macro by selecting (Tools > Macro > Macros). Once you have recorded the macro viewing the code is very easy. Press the stop recording button on the Stop Recording toolbar. Select the title placeholder and enter the title 'Another Slide'. The Stop recording toolbar should be displayed.įind the slide layout 'Title and Text' and display the drop-down menu and select 'Insert New Slide'. You don't have to worry about changing the 'Store macro in' drop-down list as recorded macros are always placed in the active presentation. Give the macro the name 'InsertingSlide'. Select (Tools > Macro > Record New Macro) to display the Record Macro dialog box. You are now ready to record the actual macro, so lets start by deleting this slide Select the title placeholder and enter the title ''. The task pane is only displayed so you can easily change the type of slide layout if you do not want a 'Title and Text' slide. You can check your options (Tools > Options)(View tab, 'Slide Layout task pane when inserting new slides'). The task pane may also appear on the right hand side. The Task Pane should be opened on the right hand side.Ī new 'Title and Text' slide should be inserted (since this is the default). If you make any unnecessary steps it will create more code than is actually needed. It is always worth rehearsing the steps before you use the Macro Recorder. We would like to be able to record a macro that inserts another slide and adds the title for that new slide.

Visual basic for applications download formulas ppt