Vba

T

Teacher

This is what I am trying to create with vba.
A game that has 6 players. ( similar to jeopardy style) for example if
player one clicks on a $5 question I want the score to automatically go to a
slide that will have a list of all their players with their scores. And as
the game progresses and they keep answering questions ....that it will
automatically keep score.
Any body that is knowledgable in VBa have any idea how to start such a
project?
 
T

Teacher

I made a jeopardy syle template ( I make these gameshows for my school) they
are all really themed productions--- I want to add the elemant of keeping
score automatically to my game shows....
 
T

Teacher

those examples are not good for my particular project......
My situation is different. I am not handing out these cds to individual
kids. I am playing this on a large screen with 6 different groups...every
group has its box that keeps score (as of now i just have a box that i can
type into it during the slideshow manually the scores as it happens) I need
somehting automatic going on
Thanks again for all your help.
 
B

Brian Reilly, MVP

Teacher,
Here's a fairly crude but working example of how to change values in
the "score box"

I created a button on Page 1 and assigned the following macro to it's
mouse click action setting.

On Slide 2, I added side by side text boxes one being for "Fred" and
one to carry the text score value.

These names and shapes are hard-coded as an example only. Don't do it
that way.

Option Explicit

Sub add_score()
Dim strscore As Long
'Picks up the existing value in the text box
strscore = ActivePresentation.Slides(2).Shapes("Text Box
5").TextFrame.TextRange.Text
'add "1" to the value
ActivePresentation.Slides(2).Shapes("Text Box
5").TextFrame.TextRange.Text = strscore + 1
End Sub

This is not how I'd do it, but that is another issue (g). But this
works as an example of the approach and you can improve on it as per
your own needs.

Brian Reilly, MVP
 
T

Teacher

to Bill Foley:
I checked out your jeopardy game - AMAZing! That's exactly what I need.
Problem is I already have my own game board. What I need is the code- ( I
dont know if you want to share it) so let me know if you are willing too?
 
B

Bill Foley

You have to replace the "at" with "@" and the "dot" with a ".". It is
merely used to minimize spamming...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top