How To Make Pictures Scrol in Text Frame

[Kieranz]

Hi,
I have pictures of similar size (2cm x2cm) eg. apple, banana, orange
etc. I would like to put these in a frame (maybe text frame) in the
top few rows which is frozen, and have them show in threes at a time
for a minute. Then as Pic01 scroll off, Pic04 comes in from the right
all happening slowly until Pic02 reaches where Pic01 was. Then the
group of Pic02, Pic03 and Pic04 will pause for a minute after which
Pic02 scrolls off and Pic05 comes in and so on. And the cycle
continues.

The idea is to get the Kids to spell the name of the
fruits. I am not sure how to go about coding this. Any help
appreciated. Using Excel2010 with Win7. Sorry for repost.
Regards
Kieranz

 

[John Coleman]

Hi,
I have pictures of similar size (2cm x2cm) eg. apple, banana, orange
etc. I would like to put these in a frame (maybe text frame) in the
top few rows which is frozen, and have them show in threes at a time
for a minute. Then as Pic01 scroll off, Pic04 comes in from the right
all happening slowly until Pic02 reaches where Pic01 was. Then the
group of Pic02, Pic03 and Pic04 will pause for a minute after which
Pic02 scrolls off and Pic05 comes in and so on.  And the cycle
continues.

The idea is to get the Kids to spell the name of the
fruits. I am not sure how to go about coding this. Any help
appreciated. Using Excel2010 with Win7. Sorry for repost.
Regards
Kieranz

Greetings,

I don't think that picture-frames have any built in scrolling
features. Possibly some 3rd-party active-x control can. Or - you could
possibly emulate it by changing the positions of the pictures as
follows:

'Untested:

Create opaque rectangles which are colored the same as the background
and situate them on either side of where you want the scrolling
pictures to be visible. Then place the pictures using a z-order which
always keep them behind any other shapes. Smooth scrolling could be
simulated by adjusting the .Left property of the pictures10 times a
second or so. On one side the pictures will be sliding under an opaque
but otherwise hidden shape hence dropping out of view. On the other
side pictures will be sliding out from under an opaque but hidden
shape hence sliding into view.

If you want kids to be able to type while the scrolling is happening
you might need to do all of this on a modeless userform.

Hope that helps

-John

 

[Don Guillett]

Here is a file by Andy Pope that may help.
http://www.andypope.info/fun/picviewer.htm
or John Walkenbach's may be just what you want
http://spreadsheetpage.com/index.php/file/slide_show_demo/

 

[Kieranz]

Here is a file by Andy Pope that may help.http://www.andypope.info/fun/picviewer.htm
or John Walkenbach's may be just what you wanthttp://spreadsheetpage.com/index.php/file/slide_show_demo/

Many thanks, John and Don. After a bit of more research it would
appear it cannot be done. But i will look at sites you have mentioned
Don.
And John your suggestion is great may have to try modeless!
Will post again if something works out.
Thks again
Rgds
Kieran