You can animate object properties by selecting the properties you want to dynamically change, selecting a data source, and defining how the data will be processed (the data conversion). To create custom animations, you can write a VBA script. To write a script for an object, right-click the object and select Edit Script from the pop-up menu. This starts the Visual Basic Editor.
When you write a script to animate an object, the script must define:
- The object that you want to animate.
- The properties to dynamically change.
- The parameters to use when processing data.
The parameters you specify vary depending on the type of data conversion you want to use. For example, if you want to use a Table data conversion, the parameters are cells of the table. Alternately, if you want to use a Range data conversion, the parameters are the minimum and maximum input and output values.
After defining these items in your script, you must connect the data source to the object you want to animate.
To connect the data source to the object you want to animate:
- Connect the data source to the input of the data conversion.
- Connect the output of the data conversion to the object you want to animate.
For more information on writing scripts that animate the properties of an object, refer to the Writing Scripts manual.
