Digital clock with date how to#

Read More: How to Make a Running Clock in Excel (2 Easy Ways) Now see the output of the code, as given below.Subsequently, the macro window will appear. In case the user wants to disable his clock, another sub-function Disable() has been created in the last part of the code.In the second portion, sub-function SetTime will keep the addition of TimeValue and present value (from when the code will be run) in Digitalclock.Later a sub-function MakingClock was assigned to the B4 In the first portion, a variable named Digitalclock has been created.Now, we will explain how the given VBA code works.Now, write the following VBA code in your Module1.ĭigitalClock = Now + TimeValue('00:00:01')Īpplication.OnTime DigitalClock, 'MakingClock'Īpplication.OnTime EarliestTime:=DigitalClock, Procedure:='MakingClock', Schedule:=False.Then press I nsert > Module to open a blank module.

Press Alt + F11 to open your Microsoft Visual Basic.

We will apply the VBA TimeValue function within our VBA code so that the code can take data from the inbuilt function to keep the time updated. The very first step of this process is to incorporate the VBA code into our Excel file. Here, we have used the Microsoft Excel 365 version you may use any other version according to your convenience. We will demonstrate in the following section how to create this digital image with adequate aesthetic features. Now, look at the screenshot we have provided below. 2 Steps to Use VBA Code for Making a Digital Clock in Excel