This is the fourth part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites are created in PowerPoint and imported in Excel as images. This part (part #4) deals with planning the clock face layout. How to make a realistic looking digital clock in MS Excel – Part… Read More... "How to make a realistic looking digital clock in MS Excel – Part #4 – (create a clock face layout – PowerPoint design)"
This is the first part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. YouTube video – how to make a realistic looking digital clock in MS Excel This part (part #1) deals with creating the digit… Read More... "How to make a realistic looking digital clock in MS Excel – Part #1 – (making the digit sprites)"
This is a video preview of the digital clock series which include a model for Excel 2003 a second model for Excel 2007 or 2010 a tutorial #1 and a tutorial #2. [sociallocker][/sociallocker] [sociallocker][/sociallocker] Read More... "A Digital Clock Model – video preview"
This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker] Read More... "An Analog Clock Model – video preview"
Hi guys, here is the final part of tutorial about creating a digital clock in Excel. It is a good tutorial about general use of sprites in animation, especially the first half. Tell us your thoughts, George [sociallocker][/sociallocker] Building an Digital Clock in Excel – part #2 – a full digital clock model using the “digit” sprites by George Lungu… Read More... "Creating a Digital Clock #2 – sprite driver, timing macro and functions, full model"
Hello! Due to some incompatibility, I re-adjusted the old digital clock for the 2007 version of Excel. In Excel 2003 or earlier if you click on a chart point twice (with a certain delay between clicks) you can paste a picture and have the data point actually convert into that picture. In 2007 the same trick works but somehow the picture… Read More... "Digital Clock Model – an Excel 2007 adaptation"
Hi guys, here is a dynamic digital clock model in Excel I made today. The display looks very realistic. I studied for this all the clocks in the house including the stove, microwave oven and washing machine clocks, plus some pictures on Google. It will display your local computer time. It uses “sprites” as a method of creating the digits. I… Read More... "A Realistic Looking Digital Clock Model"
Hello folks, here is a tutorial about building a clock in Excel. Enjoy! [sociallocker][/sociallocker] Building a live Excel clock by George Lungu Here are a few date and time functions in VBA: Now : Current date and time. Example: 7/5/00 3:16:38 PM returned by Now Date : Current date only. Example: 7/5/00 returned by Date Time : Current time only. … Read More... "How to Make an Analog Clock in Excel"
Hi guys, here is a simple file with a bunch of clocks. The code is very basic and the whole workbook is fully open so you can see how it’s done. All the spread sheet calculations are contained in the upper left corner and the VBA code is just few lines long. Click the “Run-Pause Clock” button to start or pause… Read More... "Time in VBA Part#1 – Japanese Clocks"