1 / 27

Adapting a ready made PowerPoint quiz with VBA

Adapting a ready made PowerPoint quiz with VBA. Pam Miller. Security. The security must be set to Medium for the macros to work. Check Tools, Macro, Security . You should set it to Medium, then Save, Close, Open, Enable macros and then View. Opening a PowerPoint quiz made with VBA.

jebediah
Download Presentation

Adapting a ready made PowerPoint quiz with VBA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Adapting a ready made PowerPoint quiz with VBA Pam Miller

  2. Security The security must be set to Medium for the macros to work. Check Tools, Macro, Security. You should set it to Medium, then Save, Close, Open, Enable macros and then View. Adapting a ready made PowerPoint quiz with VBA

  3. Opening a PowerPoint quiz made with VBA You must enable the macro for the quiz to work. Adapting a ready made PowerPoint quiz with VBA

  4. Now … • Look at a PowerPoint quiz made with VBA • Save the ‘perfect quiz’ in read-only safe place • Consider and change the testing file • Play and adapt Adapting a ready made PowerPoint quiz with VBA

  5. Protecting the coding

  6. Save as PPS If you save your work as a PowerPoint Show or PPS no one can get into the VBA coding and change it. File, Save as Adapting a ready made PowerPoint quiz with VBA

  7. Attaching a macro … To an object To part of an object

  8. Attaching a macro to an object Right click on the object. Select Action Settings, Mouse Click, Run macro, select macro. It must be an object and not text, i.e. it must be a text box/object. Adapting a ready made PowerPoint quiz with VBA

  9. Attaching a macro to part of an object To attach a macro to part of an object, add a small object to the small area. Do it in colour, position it, add the macro and then adjust the settings removing the fill and the border. You could first attach a macro to the large ‘wrong’ area and then another macro for the small ‘correct’ area. Adapting a ready made PowerPoint quiz with VBA

  10. VB Editor Getting VB Editor

  11. Getting VB editor Click on View, Toolbars, Visual Basic. You need the Visual Basic Editor. Click on the Visual Basic Editor Now click on VBAProject, and then on Modules and then on Module 1 and the editing box appears. Adapting a ready made PowerPoint quiz with VBA

  12. Getting VB editor another way Adapting a ready made PowerPoint quiz with VBA

  13. Changing … Macro name Message Input box prompt Title for input box

  14. Changing macro name You can change the macro name. It must be one word with no spaces. The name will change in the Run macro box. Adapting a ready made PowerPoint quiz with VBA

  15. Changing the message You can change the message. Type it inside the quotation marks. Adapting a ready made PowerPoint quiz with VBA

  16. Changing input box prompt You can change the prompt. Type it inside the quotation marks. Adapting a ready made PowerPoint quiz with VBA

  17. Changing title for input box You can change the title of the input box. Type it inside the quotation marks. Adapting a ready made PowerPoint quiz with VBA

  18. Calculations Done for you

  19. Doing calculations – they have been done for you Look at how the calculations are added and subtracted. They are based on the number of positive and negative responses. If you do not want the quiz results do not attach the macro ‘Feedback’. Adapting a ready made PowerPoint quiz with VBA

  20. Moving forward … Selecting the correct answer On click Not moving forward

  21. Moving forward on instruction from macro Look at the coding where you indicate viewing the Next slide. Adapting a ready made PowerPoint quiz with VBA

  22. Moving forward using action buttons Using an action button allows you to specify which slide you wish to link to. Adapting a ready made PowerPoint quiz with VBA

  23. No moving forward at all To prevent any meaningless moving forward using a mouse or clicking, select Slide Show, Set Up Show, Browsed at kiosk. But if you do this no animation which needs a click will work, so if you have animations make them automatic. Adapting a ready made PowerPoint quiz with VBA

  24. Displaying message

  25. Displaying a message An easy effective macro is to show a message. Copy the coding. Adapting a ready made PowerPoint quiz with VBA

  26. Displaying a message Be creative Adapting a ready made PowerPoint quiz with VBA

  27. Be creative Be creative Be creative Adapting a ready made PowerPoint quiz with VBA

More Related