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
-u
Try: View, Toolbars, Control Toolbox, More Tools, Shockwave Flash Object
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Hey U,
See if this might work for your project. Keep the excel file and the flash (.swf) file in the same directory.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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.
-u
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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........
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hi Lucas,
This would be perfect for my project.
-u
This project would be perfect for my project with the flash embedded in the userform.
-u
Can I ask for embedding the flash in that userform again? Thanks.
-u
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!!!!
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?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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
-u
You will probably want to delete or comment out the ontime code in the button code
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....Application.OnTime Now + TimeValue("00:00:8"), "KillTheForm"
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
No problem U, I'm not sure when but I will come back and see if we can polish this a little with you.Originally Posted by U_Shrestha
i would appreciate if you can have a look at it after you have entirely done with your deadline
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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.
-u
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
yes, this looks good!!
-u
just giving final shot at the problem. would really appreciate if someone can provide help me put a flash animation in the userform. thanks.
-u
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?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
