Analog clock(Timer) in Excel using VBA & Graphs | Advanced Excel Tutorial

By end of this tutorial, you'd be able to design a working analog clock in excel which has hour, minutes and seconds hands.

It requires understanding of lines using coordinates, simple calculations and very basic knowledge of VBA.

This is not designed with an intent of solving any problem statement. Rather, it is to highlight how we can control graphs using VBA. This concept can be used in interactive reports.

[robertjcliu]

This is a fascinating example for teaching programming.

[HP-swht]

Really enjoyed the video, found it fascinating what you can do with VBA. Thanks again for sharing. :-)

[mesuttasar]

Thanks for this tutorial but I think it would be more accurate to edit the code as follows, for analog Clock.


Sub saatdeneme()
Start = Timer
Do While Timer < Start + 1
DoEvents
Loop
[Sec] = [Sec] + 6
If [Sec] = 360 Then
[Sec] = 0
[Minut] = [Minut] + 6
[hr] = [hr] + 0.5
End If
If [Min] = 360 Then
[Min] = 0
End If
Call saatdeneme
End Sub

[pankajsah]

Dear Sirs,
Since 3 Months time, there is no video uploaded. We request you to upload every week a video.
Best regards.
Pankaj Sah

[neetasingh]

Arre start button ko kaise lgaye ye to bta do