Time Limited Questions

[MGumbrell]

I would like to create a game that plays up to ten seconds of music. At any stage the user can pause the music to answer the questions if they are succesful the score will appear if they are not they can restart the music and continue. Depending on how long it takes them to answer depends on their score.

Has anyone tried and succeeded with this or have a plan on how to go about creating such a game.

Regards, Matt

 

[Sergeant]

I love making simple games in XL. This "Name That Tune" game sounds do-able.
One question...How will the player answer? Will they type in the answer? Will they shout out the answer & the game operator will decide whether they are right?

User typing in the answer could be problematic (misspelling, order of artist/title, etc...)

 

[MGumbrell]

I intended for the user to type in the answer, however the way inwhich the answer is to be entered will be as explicit as possible as I understand the issues with users typing in answers. Giving prompts and methods for entering the answers which I would like to include:-
01 - Artist
02 - Title
03 - Year of release
04 - Highest position reached in the chart

I may be making this thing too big, but if I don't have soemthing to aim for then it will never fly.

Regards, Matt

 

[Sergeant]

I got something started for you...gotta go right now...be back later and post more.

 

[Sergeant]

Check the attachment. It is by no means finished...just a start.
You must place it in a folder that has some MP3's in it.
Once opened, go to the user form in the Visual Basic Editor and hit F5 to run it. To see what's going on in the code, right click on the button and select 'view code'.

The idea would be to not use the combo box for the songs, but select them via Rnd function and keep track of which ones have been played. The button uses the Rnd function to select one of the combo box items.

 

[MGumbrell]

And thats by no means just a start, that would have taken me weeks. I am currently looking at the code to understand (as best I can) what its doing.

Thank you very much for your assistance.

Are you still willing to assist?

Regards, Matt

 

[Sergeant]

Sure, but remember it was your idea. As usual, I have numerous projects underway for work.
If you need the code commented in the spreadsheet, let me know.