Adapting a ready made PowerPoint quiz with VBA

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