This is a simple tutorial of how to create a simple Running Digital clock in Excel using VBA with download VBA code link. Which help you to make or practice easily. if you have requests or would like to see how to do some other creative solution in excel, please mention in the comments and I will try to see what I can do to help or show how.


Hello friend we will going to learn how to create a digital clock in excel work sheet. Like this. Lets go to make this. I want to tell you before start to make it, please download the vba code file which is in the description box. Download and open the text file. Now open excel. In the cell a1 give now formula and change the cell format to time. Now insert a text box and link the box to cell a1 and also change the box format and font size. That’s your choice. After it go to visual basic and insert a module then open the downloaded code file and copy the all code. Go back to visual basic and p5aste the code into the module. After pasting the code ready your digital clock macro. Now go back excel work sheet. Insert a form control button and select start clock for the assign macro. And rename the button to start clock. Insert another which assign macro to stop clock and rename it to stop clock. Here your digital clock is ready. Now click on the start button. You can see the clock is running. To stop the clock just click the stop clock button. Nicely stop the clock. And check again and again by clicking those both button.
Now save the file to desktop. Save as type select excel macro enabled workbook and click to save button. After the saving close the workbook.
Open the saved file from the desktop.
You can check the clock by clicking the both button.
Thank you for watching this video. Don’t forget to hit the Like button and subscribe my channel for next video. Love you and by by.

Download the vba code : [ Ссылка ]

свернуть