Analog Clock in Excel using Shapes (VBA Macro Step-by-Step)
Вставка
- Опубліковано 5 вер 2024
- Read the post and download the Excel Analog Clock here: excelmacrofun....
In this video we see how to create a classic analog clock in Excel using VBA macros. We use shapes to create the frame and other components of the clock, including also the clock arrows or pointers. Then we rotate the arrows to indicate the current time, and keep updating the position by setting a loop or flow with VBA time functions. The clock arrows are lines grouped with an oval shape used to create the rotation of the classic analog clock in Excel.
For more Excel VBA fun applications and games visit Excel Macro Fun: excelmacrofun....
And for other Excel VBA learning resources and applications visit any of the other blogs of the Excel Macro Mania saga:
Excel Macro Class (excelmacroclas...)
Excel Macro Business (excelmacrobusi...)
Excel Macro Sports (excelmacrospor...)
Very quick and easy. I would have thought this was way more complex.
Thankyou very much, I like it!
this lesson is cool
maybe bc my excel version is new maybe the file version is old bc your video published 1 year ago so some function might not work
it's not working too I tried to download the file and then launch it on Microsoft excel it says does not support
It works. Many people have downloaded and had no issues. What is not supported? which line is highlighted with the error?
DASNOT WORK
What exactly does not work? The file on this post is working for me and many other people who download it: excelmacrofun.blogspot.com/2022/11/excel-analog-clock.html