Oct 26, 2012

Interactive Quiz in Power Point-VBA programming

Ever Thought of making a interactive  Power point Quiz in a school /college events? Want to give a nice look and feel quiz that displays whether your answer is right or wrong and proceeds you to the next Question. Here is the way. Follow the following simple steps and You are gonna make a quiz that makes you a star in your class.

VBA Macro programming aids this presentation. To start with we need to open VBA editor in power point. The following points takes you through this.


Steps to be followed :
1. Open the powerpoint Presentation. Save it.
2.  Press Alt + F11 or click Tools –> Macro –> Visual Basic Editor to open the VB editor.
3. Now the editor is open paste the following code:
'-------------Code to identify Wrong Answer

Sub Wrong()
MsgBox ("OOPS!! Wrong Answer!! CLICK OK TO PROCEED TO NEXT QUESTION")
SlideShowWindows(1).View.Next
End Sub
'-------------End of Code Code to identify Wrong Answer

'-------------Code to identify Right Answer

Sub Right()
i = i + 1
If (i > 5) Then
MsgBox ("That's right You are doing marvelous !!! Click OK")
End If
MsgBox ("That's right! CLICK OK TO PROCEED TO NEXT QUESTION")
SlideShowWindows(1).View.Next
End Sub


Sub RightLast()

MsgBox ("That's right!!! Click OK")

SlideShowWindows(1).View.Next
End Sub

'-------------End of Code Code to identify Right Answer

4. Save and close the editor.
5. Go to Ppt. Create any Question in the Blank Slide

6. Now Click Inset Tab->Shapes->Action Buttons->Place any option in slide
7. Right Click on any action button and you will see action to be performed.
8. If you are going to place the action button for right answer select Run Macro->Right
9.If you are going to place the action button for Wrong answer select Run Macro->Wrong
10. If you are going to place the action button for Last Question right answer select Run Macro->RightLast
11. You can add any number of Questions Like this.
12 Save and start slideshow.
13. When Prompted click enable macros

Whats more Your Quiz is ready.!!!

Enjoy. You can use different UI For Questions. A sample is shown for you in the picture.







No comments:

Post a Comment