<div>
could you record a macro doing the copy paste actions then analyse the VB code and see how its been done?
</div>


could you record a macro doing the copy paste actions then analyse the VB code and see how its been done?

<div>
Ivan Moala explains how to do animations using a successive series of images in this web page (and its follow-on links): <a href="http://xcelfiles.homestead.com/Excel04.html" rel="ugc">http://xcelfiles.homestead.com/Excel04.html</a><br />
<br />
Note: the demonstration &amp;&nbsp;code on the follow-on page renders poorly in Firefox. It looks much better in Internet Explorer.
</div>


Ivan Moala explains how to do animations using a successive series of images in this web page (and its follow-on links): http://xcelfiles.homestead.com/Excel04.html [http://xcelfiles.homestead.com/Excel04.html]

Note: the demonstration & code on the follow-on page renders poorly in Firefox. It looks much better in Internet Explorer.

<div>
Thanks for the answers but none of these suffice - i just need simple code to add an animation to the drop down menu. &nbsp;So when I click on my Build Tools menu my drop down should resemble the drop down when clicking for example file - static &quot;JPEG&quot; next to Open,New,Save etc - I hope I am making this a bit clearer - thanks for help so far
</div>


Thanks for the answers but none of these suffice - i just need simple code to add an animation to the drop down menu.  So when I click on my Build Tools menu my drop down should resemble the drop down when clicking for example file - static "JPEG" next to Open,New,Save etc - I hope I am making this a bit clearer - thanks for help so far

<div>
<div class="content wysiwyg-content">
Mircosoft Excel VBA Editor.<br />
I have added a menu called &quot;Build Tools&quot; to the default Excel Command Bar using the VB Editor. &nbsp;On the <br />
drop down there are four options that will each run a separate macro. &nbsp;What I require is code or method <br />
to provide an animation in the space provided - something similar to the Copy and Paste items.
</div>
</div>


Mircosoft Excel VBA Editor.
I have added a menu called "Build Tools" to the default Excel Command Bar using the VB Editor.  On the 
drop down there are four options that will each run a separate macro.  What I require is code or method 
to provide an animation in the space provided - something similar to the Copy and Paste items.

Mirosoft Excel Menu Animations

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.

Windows XP

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.