Animate a train running in Excel using 5 lines of VBA....

Using a very simple VBA code I created this video. To make this work these were the steps:
1- Column size was adjusted to 1.14 and rows were adjusted to 9
2- Create some mountains, trees and a train station in excel by just filling color in the cells.
3- Using shapes, put together a train. My preference was a steam engine train
4. After grouping all shapes to put together a train, rename the shape name. I named it 'train'
5. Make use of "FOR LOOP" to do the following:
a) select the shape
b) increment the shape range by 9.5
c) scroll column by 1 , as per the increment in for loop

That's it!!!!

Try it by Yourselves. And If you still don't get it, let me know in the comments....

Please like, comment and share if you liked the video....

Видео Animate a train running in Excel using 5 lines of VBA.... канала Tinu Mathew