ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Animate objects (https://www.excelbanter.com/excel-programming/386934-animate-objects.html)

Bill

Animate objects
 
A few years ago, a programmer I hired built a spreadsheet where he was able
to animate objects on command. Fo example, using auto_open he was able to
have the corporate logo fly in from off screen and settle in the middle of
the screen. It rotated as it appeared. He was able to set values which
controlled the speed of rotation and the speed at which it appeared. While
this adds nothing functional to the workbook, it gives it a little flash. I
can't find anything that helps me re-create that code, and the old file is
long gone in another company. Anyone have any ideas? Thanks.

Jim Cone

Animate objects
 

Maybe...
http://www.j-walk.com/ss/excel/files/developer.htm
Look for the Animated Shapes download.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bill"
wrote in message
A few years ago, a programmer I hired built a spreadsheet where he was able
to animate objects on command. Fo example, using auto_open he was able to
have the corporate logo fly in from off screen and settle in the middle of
the screen. It rotated as it appeared. He was able to set values which
controlled the speed of rotation and the speed at which it appeared. While
this adds nothing functional to the workbook, it gives it a little flash. I
can't find anything that helps me re-create that code, and the old file is
long gone in another company. Anyone have any ideas? Thanks.

Bill

Animate objects
 
Perfect Jim! Thanks a bunch.


"Jim Cone" wrote:


Maybe...
http://www.j-walk.com/ss/excel/files/developer.htm
Look for the Animated Shapes download.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bill"
wrote in message
A few years ago, a programmer I hired built a spreadsheet where he was able
to animate objects on command. Fo example, using auto_open he was able to
have the corporate logo fly in from off screen and settle in the middle of
the screen. It rotated as it appeared. He was able to set values which
controlled the speed of rotation and the speed at which it appeared. While
this adds nothing functional to the workbook, it gives it a little flash. I
can't find anything that helps me re-create that code, and the old file is
long gone in another company. Anyone have any ideas? Thanks.


Nayan

Animate objects
 
Hello There,

I am looking for something similar to animate but on the use Excel user form
(VBA form-Excel 2003) rather than on worksheet.

Any idea or suggestion?

Thanks,

Nayan

"Bill" wrote:

Perfect Jim! Thanks a bunch.


"Jim Cone" wrote:


Maybe...
http://www.j-walk.com/ss/excel/files/developer.htm
Look for the Animated Shapes download.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bill"
wrote in message
A few years ago, a programmer I hired built a spreadsheet where he was able
to animate objects on command. Fo example, using auto_open he was able to
have the corporate logo fly in from off screen and settle in the middle of
the screen. It rotated as it appeared. He was able to set values which
controlled the speed of rotation and the speed at which it appeared. While
this adds nothing functional to the workbook, it gives it a little flash. I
can't find anything that helps me re-create that code, and the old file is
long gone in another company. Anyone have any ideas? Thanks.



All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com