Sleeper: Inserting flash animation

[U_Shrestha]

I have no experiance with inserting flash in Excel but i was wondering if it is possible to show an animation like the link below if A1=B1. I am creating a interactive math lesson for grade 2-5, where students would need to enter answers in designated cells; I want to give interactive feedback upon correct or false answer. Can someone help? Thanks.

http://www.scienceacademy.com/BI/index.html

[Simon Lloyd]

Try: View, Toolbars, Control Toolbox, More Tools, Shockwave Flash Object

[lucas]

Hey U,
See if this might work for your project. Keep the excel file and the flash (.swf) file in the same directory.

[U_Shrestha]

Hello Lucas,

That was a very wonderful animation, I liked it very much. I inserted a flash object in the worksheet but couldn't figure out how I can take it from there. If I can put such animation displaying the word "Correct", when the answer is correct (e.g. in the attachment) then it would really be eye-catching for the kids. Can you please teach me how to do it in the attachment? Your help would be appreaciated.

[lucas]

Hey U,
This seems to work pretty well. Might meet your needs. I don't have flash installed on the computer I am working on right now so I couldn't create a flash that says "Correct" but this demonstrates that it can be done I think. Let me know what you think.

[lucas]

U, If you are having trouble figuring out the target....click on one of the cells that have answers and you will see it's name reflected in the name box in the left end of the formula bar......that is the name used in the code........

[U_Shrestha]

Hi Lucas,

This would be perfect for my project. :)

[U_Shrestha]

This project would be perfect for my project with the flash embedded in the userform.

[U_Shrestha]

Can I ask for embedding the flash in that userform again? Thanks.

[IrishCharm]

i just took a look at that and it is class, great for putting into spreadsheets to make them more "happy" to use rather than mundane and boring!!!!

[lucas]

U & kinkyKuddles, I'm sorry I missed your followup questions. I got caught in a deadline and have been going like crazy. I will take a look at this with you soon if someone else doesn't step in.

What exactly are you trying to do? You want to load a userform and then click a button to run the flash within the userform? not sure but you may have to run another userform from the first.....would that help?

[lucas]

All I did was to move the code to run the flash from activate to button click. I made the userform a little bigger to accomodate the button. You can change the background colors some......to make it prettier.

[U_Shrestha]

hi lucas,

thanks for getting back. i want to make an educational game for the kid, so my worksheet will have sums like 2 + 2 = "", if a kid enter correct answer then I want to show a flash saying "Correct answer" or "well done", something that will make mathematics more interactive and exciting for kid. I liked your last attachment with the userform, I only need a flash in that userform now. i would appreciate if you can have a look at it after you have entirely done with your deadline :)

[lucas]

You will probably want to delete or comment out the ontime code in the button code


Application.OnTime Now + TimeValue("00:00:8"), "KillTheForm"

And you probably won't want it to load on workbook open so you can delete or comment out the code in the thisworkbook module....

[lucas]

i would appreciate if you can have a look at it after you have entirely done with your deadline :)

No problem U, I'm not sure when but I will come back and see if we can polish this a little with you.

[U_Shrestha]

i am looking for something like this attachment lucas, this is the one you sent to me last time. it will be even better if there are 2-types of animation, one for right answer and another for wrong answer. thanks.

[lucas]

A quick setup of the basics......I don't have flash where I am so I used the same one on a different userform.......look at the case else statments in the code for the worksheet.

[U_Shrestha]

yes, this looks good!! :)

[U_Shrestha]

just giving final shot at the problem. would really appreciate if someone can provide help me put a flash animation in the userform. thanks.

[lucas]

Hi U, Are you looking for someone to create a small flash, one for correct and one for incorrect? Or do you have your flash and need help installing it?

[U_Shrestha]

I am looking to see if someone can create it small flash for me, one for correct and another for incorrect. I don't have any experience with flash yet. Thanks lucas.