Open Microsoft PowerPoint and click on File > Options > Customise Ribbon > Checkmark Developer Tab > Click OK. Now make PPT Games using VBA Developer Macros!
We will be exporting/sending the results of the PowerPoint Quiz to an Excel Sheet automatically. The excel sheet shall contain the name of the student which was inputted by them in the presentation along with their location.
We also send the number of correct answers, wrong answers, the percentage and points secured by the student to the same excel sheet.
However the best feature is that we export all the questions of the PowerPoint Slide along with the answer which was attempted by the student to the same excel sheet! All of this is done automatically!
We will be shuffling the order of the questions such that all the questions are shown to the students with no repetition. We achieve this by generating random orders and moving slides to a random position within a given range.
To generate the order of those multiple choice answer boxes, we rename those four boxes as “a1, a2, a3, a4”. And then, we make an array and shuffle that to get all the 16 combinations of “1,2,3,4”. Based on the order of the sequence, the answer boxes: “a1, a2, a3, a4” are arranged in slide-show mode.
In this module tutorial, we shall be seeing how we can be redirected to a random slide in PowerPoint using Visual Basic Code.
In our module we have six different slides containing unique names from A to F. I need to be redirected to any one of those slides randomly on the press of a button.
I also need to make sure that I am not being redirected to the same slide consecutively in the case that the same random number is again generated.
So now, let us shuffle our slides and get hyperlinked to a random slide in Microsoft PowerPoint.