Create a Number Score/Points Counter in PowerPoint [PPT VBA Tutorial]
HTML-код
- Опубликовано: 15 сен 2024
- //DOWNLOAD POWERPOINT POINTS COUNTER TEMPLATE & VBA CODE:
pptvba.com/how...
Use KeyBoard to control the counter: • Points Counter in Powe...
Having scoreboard in all your slides: • Scoreboard Counter acr...
In this video, I show you how to make a PowerPoint counter which can count and keep points and scores. Something like a Scoreboard.
This PPT counter will be controlled by two buttons which will either increase or decrease the value by 1.
We add the VBA code to a button or a shape in the slide, on clicking the button, the macro is run. The macro increases/decreases the caption of the label by +1 or -1 in this case. You can customize this to fit your needs
These can be used in a variety of ways such as for quizzes in the classroom or conducting trivia competitions or quiz shows such as jeopardy or if you just want to keep scores or points for any soccer match.
----------
Enable Developer Tab: • Show developer tab in ...
PPT Scoreboard Tutorial: • Creating Points Scoreb...
----------
I also do freelancing, contact me:
🟥 Bhavesh Shaha,
📧 bhavshaha@gmail.com
🌐 www.pptvba.com
🎥 / bhaveshshaha
📷 basicallybhavesh (DMs are open)
YOU'RE one of the FEW OF RUclipsRS THAT DO A SIMPLE AND PERFECT TUTORIALS!! Very good!!
Thank you very much for the kind words!
could you make a video in which you do in a powerpoint presentation a scoreboard with countDown and a stop for it???
You can add a time setting in the transitions. After a certain time, the slide will go next. You can have a box wipe animation and you can set your desired time. If this isn't clear, I'll try to make a video tutorial.
Bhavesh Shaha thank you so much!
You are welcome! Thanks for watching.
Maashaa Allah.
Honestly explained.
Very clearly, step by step.
I like your all video lessons.
God bless you.
this is what i was searching foooor!!! reallyy many many thanks!!
You are a GENIUS! Subscribed and thanks!!
Glad I could help! Thank you for watching.
Thank you so much, Bhavesh. You're amazing!
thx u Bhavesh Finally it works after i click enable my macro on powerpoint
Glad to hear that! Have fun with VBA in PowerPoint!
Liked!
Fast and Easy! Thank you!
wow Nice....... thanks dear
Very helpful! Thank you :D VBA always get me ;D
Thank you for watching :)
Wow excellent
super! thank you!
Great video except I followed everything step by step but run macro option in action settings was greyed out. Checked macro security settings and all set to enabled.. so couldn’t assign action to the buttons so didn’t work for me.
That's odd. What version and OS are you using?
Thank you very much!!!
Thank you for your amazing work, if u could help me in my situation, i have a slide and on each click on the slide i want the counter to move by one but after 10 clicks it needs to stop.
Hi Bhavesh. I'm a fan of yours. Great work! I was wondering if you could show us how to put two of these counters side by side on the same slide for when two teams are playing a game.
Okay. I'll upload that as soon as possible.
Thank you for your positive comments.
I would appreciate that very much, Bhavesh!
ruclips.net/video/3WbJCGoSzhU/видео.html
It's done.
Bhavesh Shaha its great but what is the meaning of this game
Bhavesh Shaha I want write musicnotes in Powerpoint and
make a book or make a
animated movie !
Can you tell me how to do this?
this helpful, thanks
Thank you for watching.
thanks, can you make a scoreboard for students that arrange them from highest to lowest socres,, tnx in advance
Bhavesh, thank you very much for the video. How can I make the counter to start automatically when I open a slide?
You want the counter points to be added automatically? or do you want the counter in your first slide in slide-show-mode?
Bhavesh, you are the most responsible person out there! I need to start counter when the slide shows up during the presentation. Is there an “on load” routine for the slide? If not, I can compromise with a command button to start count down. Thank you very much.
@@yakovgoldin oh! You want to have a countdown? You can make that using animations. This one is a counter. In this, we add or remove numbers. In a countdown, it works differently. Please contact me at 2002bhavesh@gmail.com so we can discuss further.
Hallo, wonderful explanation . but one query is there....i have tried to save the file in macro enable show mode and as i clicked that file to open it shows error and stops to open the file in autorun mode. can you explain how to sort this problem.
Please share the specifics of the error as a screenshot to my email.
No editing in properties is available
so helpful, thank you so much!
Glad it was helpful! Thank you very much!
want to make a quiz power point but that i can send to my students but that they wont be able to edit or do changes but simply do the quiz and be graded. I can do the interactive quiz and graded but the non editable is my question on hand.
1. You can password protect the file for editing (read-only)
2. You can save the file in pps (Powerpoint Show)
So, by this your students will be able to see all the slides of the PPT in normal view (there's a loophole, you have to open the pps show via a PPT window)
But, if you protect it with password and make it read-only.. your students will be able to see all the slides, but they won't be able to make changes.
I recommend that you try the above. I also recommend you trying to find loopholes which could be exploited by them.
In my opinion, I don't think that PPT is the software suited for these things.
Try making an online form with add-ons (Google forms). Google Forms has an add-on which can grade your students according to your answers and automatically arrange it in a spreadsheet.
There are many other softwares more suited for these kind of things though. Please try googling it.
I'm sorry for the late response.
Hello, why when i clik on the circle my numero disapear ?
Thank u for this tutorial, i want to ask what to do if i want the counter to be in all slides, and each slide will take the counter number from the previous slide and add or subtract from it
ruclips.net/video/K05wWVbqzVI/видео.html
This video will make the counter appear in all slides with the numbers having continuity.
ruclips.net/video/K05wWVbqzVI/видео.html
This video will make the counter appear in all slides with the numbers having continuity.
Thanks for this tutorial. Is there a way I can do the decrease/increase via keyboard? And not clicking on the slide? Thanks
Yes! ruclips.net/video/pvqNNwubr4E/видео.html
Thanks! I appreciate this. very easy to understand.
I think I get how to do this but I have windows 365 for Mac and it doesn't have the developer tab. I downloaded one from another web site but it doesn't have the "A" (label) option there. Can I use the custom action shapes or normal shapes?
Basically I can write the code and have a trigger but no where that will add up the result.
Hello! Macs do not support ActiveX Elements, so we cannot have the Label.
We can use a normal shape and have this code:
Sub AddOne()
Dim nameoftheshape as TextRange
Set nameoftheshape = ActivePresentation.Slides(1).Shapes("nameoftheshape").TextFrame.TextRange
nameoftheshape = int(nameoftheshape) + 1
End Sub
Note: you can set the name of the shape from the shape selection pane.
@@PPTVBA
know this video is quite old so thanks for replying and so quickly too.
My code was quite close but had the “counter.Container” part with the new name jumbled up too much. I’ll be using this for teaching my students in class so this was quite helpful thank you. Subscribed
Thank you! Glad that I was able to help out. Your students will love your class!
@@PPTVBA hello again.
The code you gave me says there's a mismatch error. Now it is saying the shape is not in the collection...but it is in my selection panel. I Used the exact code you gave me and change the object name to apple. I know your busy but what do you think happened?
Have you changed the "1" within the brackets of the Slide(1) to point to the correct slide number that contains the shape?
Parabéns. Muito Bom
Thank you very much.
Hello,
How do you put more than one counter on the same slide and let them work seperately
ruclips.net/video/3WbJCGoSzhU/видео.html
This video explains that!
Can you show us the way for creating a MCQ on PowerPoint
ruclips.net/video/mGp3HsLKXb4/видео.html
Here is a video that showcases a MCQ Quiz with Points.
you use filmora? so do I
Filmora and Camtasia.
At first it works just fine, but after saving and closing the file, it won't work. Any idea on what is happening?
Hi there! Please check if your macros security is enabled in PowerPoint. Go to Developer > Macro Security > Enable
How do I make the counter + or - 100? Just change the code? Also, how do I add it to an existing PPT?
Make this in your existing ppt and change the code to represent plus or minus 100.
Thank you for the tutorial! I tried to test the macro but the points won't go up or down when I click on the arrows. Do you have any idea how to solve this (I'm a beginner in VBAs/macro's..)? Thank you!
Hi! That's odd, can you send the file over to my email? I'd be happy to have a look. Common errors could include that the name of the label and the name mentioned in the code might not be exactly the same, it is case-sensitive.
Hello my friend.. I have a problem with this counter. When ı saved it with html5 it is not working. Also it is not working when I saved it pptx with macro .. Help me please
VBA works only on .pptm and .ppsm, doesn't work in HTML.
When you select arrow to increase number, can you make the text have an animation?
We wouldn't be able to do that as the 'text' is a caption of an ActiveX Element Label.
I enjoyed the video however, I was unable to get the counter to work. I reviewed the video and followed along and did exactly what you demonstrated in the video. Any suggestions on how I can make it work? Also, how can this be used in a powerpoint presentation?
templates.bhaveshshaha.com/download-powerpoint-scores-points-counter/
I've mentioned its uses in the above article.
You can just make this type of counter in a slide-master-layout and embed it within your ppt file.
You can download the .pptm sample file which is provided in that link and check if that is working.
You'll need to enable the macros to make them work. Go to Developer > Macro Security > Enable.
Thank you.
How do I get it to work for 2019 I tried many times and it didn’t work please help...
It should work. I've tried it on 2019. Make sure you macros are enabled by going to developer > macro security > enabled. Also make sure your coding is correct; you can also download the template from my website and check if that works.
Please guide that how can we enable the developer in MS Power Point 2007?
HOW TO ENABLE DEVELOPER TAB for 2007:
Click the Microsoft Office Button, and then click PowerPoint Options.
Click Popular, and then select the Show Developer tab in the Ribbon check box.
Thanks :)
Very useful the video. what should i do if i want the counter back to 0 in 2-3 hours for example or every day ? is any code for it ?
You would have to reset the counter manually. You can use the reset code that I've shown in the video. Make the .Value = 0.
Thank you very much for answer. One more questions i want to know if is possible .How i can link two shapes/labels together when i am updating one in slide one the other one in slide two to be updated automatically. If is not possible updating at least is possible to link two counters in two different slides to be updated by one shape from one slide ?
Thank you very much:)
I'll write a blog post on it and link it over soon. It's pretty easy to do it but it would be hard to explain without visual aid.
Thank you!
@@PPTVBA Thank you very much .
Thanks so much for this! After googling for what seems like a lifetime this vid showed me what to do straightaway. Any chance you can show how to go to a slide depending on what the value of the counter is? Eg go to slide 10 if counter is > 0 and < 100...(hope that makes sense)
Definitely! Have another macro:
Sub gototheslide()
If counter.caption > 0 AND counter.caption < 100 then
ActivePresentation.SlideShowWindows.View.GotoSlide (10)
End If
End sub
@@PPTVBA Incredible. Thanks so much for your help, really appreciate it!
Thx for this great tutorial. Can I use the Template in different master master Layouts? When I use them in one Layout it works. But I will use them in different Layouts.
Yes you can use different layouts, you just need to update your codes accordingly.
now how do you make multiple counters on one slide for a multiplayer score counter
I have uploaded a video on that too. Pls checkout *multiple counters in pptvba*
how do I put the same counter in another slide, but the counter will count from the same number?
I tried Slide master but I cant get it to work
Bhavesh Shaha
I don’t know how to do that 😅😅
I’m not that good when using the slide master,
And I just asking it to be in certain slides, and not all of them
ruclips.net/video/K05wWVbqzVI/видео.html
This is the video which will help you have the scoreboard in the slides you want
Good need to
though i enable macro security in action macro radio button is not enable..?
Why do you need the radio button?
i made the counter program and write all the code but in ppt when i click on run macro in action setting that button is disable. what i have to do for enable that button
Thats never happened before..
Have your tried googling it?
yes and all results are same as you explained ..
Tried re-installing or updating your MS Office?
Thanks but how can I make the counter number go up to 150 before exit to zero
NtaUSA Atlanta you want the maximum number to be 150?
yes pls
NtaUSA Atlanta I'll look into it
NtaUSA Atlanta for what purpose exactly?
I am using it to do a counter that require numbers from 1 - 150 but your tutorial can only count to 99
Hi! Thanks for help. How to add another score to slide ?
ruclips.net/video/3WbJCGoSzhU/видео.html this tutorial explains that
Gracias :)
Eres genial...gracias por compartir :)
Thank you very much for the kind words.
Anyway to learn all of this technically
Hi, Bhavesh. It's been a year since I asked you for help with the scoreboard. One of my Taiwanese colleagues is also using it. I'm very grateful for your generosity. I came across a different kind of ppt that I use sometimes. There are 2 files within the same folder, a ppt and a txt. When I open the ppt in show mode and click on a certain button, two random words from the txt list appear on the slide. This can be used in various ways, for instance picking two random students to participate in an activity. I have also used it to pick two random words for sentence games. I'm not certain if this change is possible, but can one have two txt files from which one word/name is selected from each. If it is possible, I could choose one student from Group A and another from Group B, or instead of two random words, one from a noun list and another from a verb list. Do you think it's possible?
Can you link me to the ppt where the text files are used? I'm hearing about this for the first time. Thank you.
Here's the link, Bhavesh: ruclips.net/video/HpOfnwT9YFU/видео.html
Due to my settings, the comment ended in the spam since it contained links. Sorry for that, I'll go through it and reply soon.
Can my counter skip numbers. For example, I want to count from 1-10 then skip and count 21-30
Yes, use the following code:
If Counter.Caption = 11 Then
Counter.Caption = 21
End If
Hello how can I make 5 scoreboards in just one slide?
ruclips.net/video/3WbJCGoSzhU/видео.html
This video should help you out!
How do I make it for more than one counter? I need three! Thanks!! The first counter worked, I tired to make it for the second but values didn't change. Help!
You'll need to have 3 different labels with different names. Then change the code accordingly. REMEMBER: The names must be case sensitive while coding and no two labels can have the same name.
I noticed that you have another video for more than one counter, but I need to keep this format.
You can just design it differently and keep this format. Use the same codes and just replace the names of the labels.
I tried changing the labels and adding different names, but the first label is the only label that changes values
Is the name of all the three labels different? Are the codes changed corresponding to the label name?
For label1, label1.caption = (label1.caption) + 100
For label2, label2.caption = (label2.caption) + 100
Remember to change everywhere correspondingly.
Thanks a lot, this really helped me doing what I planned to do but I have a question. +I`m trying to do a multiple choice quiz and use your routine to keep a score counter. For example:1st slife has a sentence "My ??? name is Marc." then just below I have 3 butons "home", "name" and "job". Students then have to clikc on the correct answer (name obviously) which gives them 1 point on the score counter. If they hit one of the other 2 options, they get -1 point.Now I wanna use multiple slides with similar 3 choice questions but wanna keep the score counter across all the slides. How could I do that?
ruclips.net/video/K05wWVbqzVI/видео.html
This is the video where I show how we can keep the counter across multiple slides!
Thanks Bhavesh, I tried but it dosn`t work. Guess my file is messed up somewhere :(
@@rawjapan6808 Pls send me the file. I can have a look at it.
Really? That wuld be awesome!! Where can I send it to?
@@rawjapan6808 to my email please. It is in the descripton.
Sorry icant speak english very well
I want make counter count 6 and after 6 goto next slide or next action ?
We need to add an If-Condition for that.
If counter.caption = 6 then goto slideshowwindows(1).view.next
@@PPTVBA thank you so much
what about in excel?
You can insert an ActiveX Element and the same code would work!
Dude, you are THE BEST!!! Exactly what I needed!! \(^_^)/ Thank you so much!!
Ayy! Thank you so much! Don't hesitate to email me if you need any more help! xx
taaaaaanks
I need your help to set up below macro in PowerPoint to be enable when I click on specific caption
For example
I want to add 5 different captions Monday, Tuesday Wednesday, Thursday,Friday
Currently I add two shapes - and + near TeamBarometer caption and I can control this which is great but I need when I click on Monday to work for Monday , when I click on Tuesday to work only for Tuesday etc
I don't have much experience and I really need your support
Sub TeamBarometer_minus () TeamBarometer.Caption = (TeamBarometer.Caption) -1 End Sub Sub TeamBarometer_plus () TeamBarometer.Caption = (TeamBarometer.Caption) +1 End Sub
Thank you in advance
Can you please send me an email with your PowerPoint file? You can use the *hire/contact me* section on our website: pptvba.com
Hi Bhavesh, thank you for your video. It is very helpful. I do have a question though. would be possible to create on powerpoint, a point scoring system like the one is this video ? (top of the screen, starting from 3:57) ruclips.net/video/8O6m-iI69vg/видео.html if so, would you be able to show me how please ? Thanks again for the video
Yes, this is definitely possible, you can toy around with various slide masters and using some smart hyperlinks, it would be possible! Adding VBA for changing the colour of the shapes and your module would be created! However, I could create one for you since I also do freelancing. If you are interested, please send me an email with your budget and exact requirements.
Have this scoreboard/counter across multiple PPT Slides: ruclips.net/video/K05wWVbqzVI/видео.html
Use KeyBoard to control the counter: ruclips.net/video/pvqNNwubr4E/видео.html
Download code and file: pptvba.com/counter-keyboard/