Coding a Matching Game using PowerPoint and VBA Part 7

[@GabrielLima]

I really have to voice my appreciation for your tutorials. I had to make a Powerpoint with a few interactive features and I couldn't find a decent tutorial anywhere. Going through your matching game made me understand just about enough of VBA programming to allow me to do what I wanted. Thanks a lot for taking the time to post these videos!

[@Awayzo]

Wow. Thank you for taking the time out to voice your appreciation. Trust me. This sort of comment is why I make videos. Thank you. Thank everyone that watches and extra thanks to those of you that leave a comment.

[@macatiedemann]

Hi Malik, another teacher here! Thank you so much for taking your time to post these videos. You have no idea how much you are helping us in this difficult time! For long time, I wanted to learn to code as an alternative to my current job, now, you have shown me how coding indeed helps my current job. Thank you from the bottom of my heart!

[@Awayzo]

Thank you for watching and taking the time to write such a beautiful response. Thank you.

[@rocio2917]

Love the help. Thanks! I also appreciate "the LEAST that you can do" advice. I admit that I was pretty lost not knowing what to expect with each video as I didn't know how many are in the series.

[@Awayzo]

I completely understand. However, because I do not do this for monetary gain, I don't make it has polished as I could.

[@rocio2917]

@@Awayzo I understand. I am curious as to the point of subscribing if itsn't to eventually montize. Either way, I appreciate the help.

[@shanrich2gether]

THANK YOU Malik!! You are a lifesaver with this coding training! I look forward to going through your other videos to continue learning!!

[@Brinatsuyu]

Malik, your videos are awesome!! I've been trying for years to find a video like this that teaches how to create a memory game like this one. I am creating a reading program and the interactive part (score and showing if they matched the cards correctly or incorrectly) is so important for children who are learning their letters and learning how to read. Thank you soooooo much! You are a great teacher because you go step by step and don't skip anything.

[@johnhillman2619]

Thanks for a very nice tutorial, Malik. Although I have written VBA behind Excel, I was having problems with PowerPoint VBA. This helped a lot.

[@michaeltotton5925]

Hi Malik, great set of videos. Would you be able to make a video that shows how to use pictures instead of words and how to shuffle the cards around so they are in a different place every time

[@christinegriffin9327]

Thank you so much for this video series and your easy-to-follow explanation of the processes and the code! I watched the drag and drop game videos before this one lol! I should have watched this series first! Now I may be able to reset the puzzle pieces in the drag and drop puzzle game on my own! Also, could you let me know what I would need to do to randomize the shapes for the matching game...please? :-) Thanks again! Christine

[@breandan789]

Very helpful tutorial. I would like to expand by using pictures ... so a card has a picture of a dog, and the matching card has the word dog. Using TextRange is easy enough for modifying shape text, but to display a picture? You mention the Fill property, but I see nothing in there about pictures. The closest thing I can find is the AddPicture method under the Shapes object - but this appears to create a shape from the selected picture. I'm relatively new to VBA, so I may be misreading the documentation.

[@Awayzo]

I have a video on creating a storyboard and it shows how to do what you want. Here is the link:kzbin.info/www/bejne/eoaxfmt9m8ihe80

[@simoninparis]

Wow! Another inspirational video! After months of struggling with PptVBA, I think I am starting to understand the logic. I am now motivated to use what I have learned to build two new games. Thank you! BTW Malik, do you have a tutorial package showing how to get PptVBA to determine the action of a Ppt presentation based on the value of a cell in a table linked to an Excel file (or am I asking too much)?

[@kimberlyryan3234]

Hello Malik! First of all THANK YOU for your video tutorials- they have been extremely helpful and I appreciate you providing this type of information. I am very new to this and this is my first attempt at something like this....I now think I should have started with something less complicated but now I am too far into it to give up! Everything was working for me until I started adding additional cards; now the score isn't working; and it isn't resetting for me (some are but not all); Can I paste my code here to see if you see a glaring problem?

[@melliedalton4165]

Thank you for your videos. As in great style as we were finishing my system froze and deleted most everything. Is there somewhere I can look to just maybe copy the code? Again thanks so much for these videos. A real help.

[@Awayzo]

Many times I may not have the code because I do the videos and delete the project. I think it is because I am not doing it for any monetary gain, I just do it to help others learn so it is not as polished as it could be.

[@arethavpi1219]

where is the previous video?

[@ekadiyana7366]

Hi Malik, great set of videos. but, what if i want to use pictures? i dont want to use word. Teach me, pleaseeee

[@cosymedia2257]

Thank you!

[@myrahuffman533]

Malik, I'm so excited to use this PowerPoint with my students this fall. However, I've encountered a problem completing it. I've created the code for this game by completing two separate PowerPoints. I encountered the same problem on each of the two independent trials. When I attempted to troubleshoot (with my limited knowledge) I discovered that when I added the command, ResetAllShapes, in the start routine, Slide 1 stopped in its transition to Slide 2 and then the PowerPoint froze. When I removed this command, Slide 1 transitioned as before but when I clicked on Card_A_1 in Slide 2, the color went to background black and the PowerPoint froze once more. Can you help me understand what happened and how to fix this?

[@Fiel1931]

Hi Malik! Great video, it has been very helpful in my efforts to create a matching game for my class. I am running into a bit of a wall in terms of my coding and am trying to get my file to match a word with a phrase. Is there a way you could help me review where I might be "stuck"? Thanks again for the content, it's very helpful!

[@Awayzo]

This is great news! I am happy it was helpful to you. However, my time is slim these days and I don't think I can. However, I will make an effort to put a word matching game on my list for awesome teacher like your self. Thanks for watching and your students are lucky to have you.

[@mcsdasabbathschool763]

Hi Malik,Also could you include an attachment with the code so that it would be easier to compare code when something doesn't work I can have your code to consider.

[@Awayzo]

Although I did do just that on a previous video, I failed to do it in this one. Thank you for the suggestion and thank you for watching.

[@mcsdasabbathschool763]

Hi Malik, First I want to thank you so much for your coding. It is exactly what I needed.I would like to know how to change the text on the cards. How to change the text or how to use pictures?

[@Awayzo]

You can change the text on the card by accessing the textRange property of the shape. like this: ActivePresentation.Slides(place the slide number here).Shapes(Name of shape here).TextFram.TextRange = "The name you want here." You can add a picture to the shape by using the Fill property.

[@ellensingleton]

Thanks, it is working perfectly now. To capture the students attention when the cards do not match, I put a one second delay to give them time to see the incorrect answer and I have also changed the color of the incorrect card to capture their attention. I have scripture on one card and the verse name and chapter on the matching card. You really gave me exactly what I needed in this program. I totally appreciative.

[@Awayzo]

@@ellensingleton This is great news! Thank you for sharing...I will upload more soon

[@ekadiyana7366]

@@ellensingleton how if i want to use pictures? i dont want to use word. can you teach me, pleaseeee

[@mariontingley2714]

Hi Malik - Yet another teacher trying to make powerpoint feel a little more interactive. Having managed to make 3 paired boxes work, when I added 2 further pairs I found that it let me click on a previously selected correct card - which would "wrong match" then default both wrongly matched cards to default colour. How can I fix it so that I cannot select an already selected "correct match" card? I'm an absolute novice to VBA so would appreciate a little guidance...!

[@Awayzo]

I am not trying to make PP feel more interactive, I am trying to show the leaner that code is everywhere and you can even manipulate PowerPoint with code that can be used to make money, get a job, or start a business if you are good enough. With respect to your issue, it sounds like a shape is misnamed or a shape has a wider dimension than is visible on the screen.

[@juXpiter]

Hi Malik! Please help!!!!!! Urgent work!!!! I tried coding exactly the same as yours but when I include If Not shp.TextFrame.TextRange = "Start" Then shp.TextFrame.TextRange = "" My start shapebox can't seems to press or work or even go to the next slide. And if I remove that part, the letters remains and did not reset. Kindly help pleaseeee!

[@Awayzo]

Are you pressing and holding or pressing and releasing. The app is particular about that. Also, make sure the shape is named properly.

[@arethavpi1219]

I can't tell what video is first or last

[@andwithbigr]

If they have a right Match, how to make them disappear?

[@Awayzo]

Make the transparency = 0

[@LearningSimplifiedCSIP]

Hi Malik, I have written the same code as yours but my code is showing absurd behaviour. I am not able to identify a bug in my code.

[@Awayzo]

What is the error?

[@LearningSimplifiedCSIP]

@@Awayzo There is some logical error. How can I send you my code?

[@Awayzo]

@@LearningSimplifiedCSIP In the spirit of learning, it would be best to copy it and paste it here as a post so everyone can learn from it.

[@Awayzo]

@@LearningSimplifiedCSIP A logical error means something could be misspelled.

[@Awayzo]

@@LearningSimplifiedCSIP It is a good idea to check for missing quotes and missing end subs

[@ameensahab4564]

HELO MALIK, kindly need your help, i need to change the integer of selected text frame like A,a,B,b ...into word, ..how can i do?

[@Awayzo]

You would have to change the variable value in the code to what you want then change the name of the shape to what you want after the underscore_ Remeber the code is searching for the shape's name after the underscore.

[@ameensahab4564]

@@Awayzo Sub Card_A() clickCard ("towards_1") End Sub Sub Card_a_lo() clickCard ("first_2") End Sub i ve done like this for example, and also change the name of the shape after the underscore, but it result to "sorry not match. try again"....

[@ameensahab4564]

is it any wrong somewhere??

[@LearningSimplifiedCSIP]

Hi Malik, have you seen my code?

[@Awayzo]

The problem looks like your system doesn't want to see the first Start button text. I believe this should get your app working... 1. Change ----------------------------------------------------------------------------------- Sub ResetAllShape() For Each sld In ActivePresentation.Slides For Each shp In sld.Shapes If Not shp.TextFrame.TextRange = "Start" Then shp.TextFrame.TextRange = "" If shp.Fill.ForeColor.RGB = SelectedColor Then shp.Fill.ForeColor.RGB = DefaultColor End If End If Next shp Next sld End Sub ----------------------------------------------------------------------------------- TO ------------------------------------Copy below---------------------------- Sub ResetAllShape() For Each sld In ActivePresentation.Slides For Each shp In sld.Shapes If shp.Fill.ForeColor.RGB = SelectedColor Then shp.Fill.ForeColor.RGB = DefaultColor End If Next shp Next sld End Sub -----------------------------------------------------------------------------------

[@ghadeermath2066]

THANK YOU MILLION TIMES I HAVE QUSETION I WANT MAKE SAME GAME BUT WITH MULTIPLICATION QUESTION QUESTION AND ANSWER ARE SHOWING AND THE STUDENT CLICK THE Q THEN ANS if choose correct q and ans the q and ans hidden until all q finish ITS FOR PRIMARY STUDENT OR WITH PIC HOW CAN I DO IT IN CODE

[@Awayzo]

To use this same code, you can just make the cards cover have the multiplication on the front, then they have to choose the answer below.

[@ghadeermath2066]

sent email for you about my idea ...i hope you answer my question