Browse » Home
Wednesday, January 23, 2013
How to Animate a Cell in Excel 2007
Download and Install the 3-D Animation Engine
1. Download the 3-D Animation Engine for Excel---you cannot animate your cells without it (see References).
2. Select your correct Internet connection from the drop-down menu next to 'Estimated Download Time:' and click the 'Download' button in the upper left-hand corner of the Quick Details information box.
3. Save the download file to your computer's desktop and double-click on the saved file to activate the installation.
4. Install the 3-D Animation Engine, following the prompts provided by the installation wizard.
Animate
5. Open the Excel Binary Workbook that was downloaded when you installed the 3-D Animation Engine.
6. Insert the object you wish to animate by clicking on the 'Insert' tab from the Microsoft Office Fluent Ribbon on the Binary Workbook. Select 'Illustrations,' and click 'Shapes.'
7. Pick your shape and click 'Animate!'
8. View the animation by placing a check in the 'Step Run?' check box and clicking 'Animate!' again.
9. Change the shape's direction by clicking 'Reverse' if you wish. You may also change other parameters of the object by using the Parameter Table in the upper left-hand corner of your worksheet.
10. Click 'Export to Light' once you are satisfied with the animation of your shape.
Create Lighting Effects
11. Open the Lights worksheet to apply lighting and shadow effects to your shape. Your object will automatically appear when you open the Lights worksheet.
12. Click 'Shed Light.'
13. Adjust the light's reflection on your object by using the sun controls on the left-hand side of the worksheet.
14. Apply different textures to your object using the controls on the top of your worksheet.
15. Color your object with the color controls, and click on the shadow controls at the bottom of your worksheet to create mysterious shadow effects.
16. Click 'Snap' and name your object when you are finished adjusting the lighting effects.
Generate Visual Basic Code
17. Open the Recorded Tracks worksheet and your newly-named object.
18. Open your Visual Basic Editor by pressing on 'Alt' and 'F11' at the same time.
19. Select the Microsoft Office Button in the upper left-hand corner of your screen and click on 'Excel Options.'
20. Ensure that the 'Show Developer tab in the Ribbon' button is selected from the Popular submenu and click 'OK.'
21. Click on the 'Developer' tab and select 'Module2.'
22. Press 'F5' to run the code after placing your cursor at the beginning of the Immediate window where the Visual Basic code is shown.
23. Copy and paste your Visual Basic code results, after they have run, into the cell in your Excel spreadsheet to run your animated object.