+ Reply to Thread
Results 1 to 8 of 8

Please how to create a digital clock

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Please how to create a digital clock

    Hello EXCE HELP
    Hello every one
    Please and if possible is what we can create a digital clock like this picture in the userform1.
    Thank you in advance for help
    Cordially
    MARTI
    digital clock.png

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,178

    Re: Please how to create a digital clock

    you need 10 icons on the form (invisible) as a picture.
    then swap them out every second, to visible ones on the timer grid.

    using a timer in Excel is a pain, but here's the code. (also google it)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: Please how to create a digital clock

    Hiii ranman256
    Please if you can put me this code in a userform for example ..I am very beginner in vba and I do not understand except as an example userform
    Thank you in advance for help me
    Thank you in advance for your precious time sacred for resolve my problem
    Cordially
    MARTI

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Please how to create a digital clock

    Hi ranman
    Try this file
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  5. #5
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: Please how to create a digital clock

    Quote Originally Posted by YasserKhalil View Post
    Hi ranman
    Try this file
    Hiiii Yasserkhalil
    Thank you for hrlp and for this good file
    But I want a digital clock..I have an example for digital clock but I have not managed to create a clock like this directly in my userform
    Cordially
    MARTI
    Last edited by Mart Marti; 08-03-2015 at 06:03 PM.

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Please how to create a digital clock

    Hi Mart Marti
    you can import the userform and the module by navigating to VBE edior (Alt + F11)
    Right click in Project window on Module1 then Export file to desktop (for example)
    Do the same with the userform ...and export it to desktop

    In your file in vbe editor, you can right click and Import both the userfrom and module
    Finally in workbook_module paste this code
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: Please how to create a digital clock

    Hiii Yasserkhalil
    Thank you a lot for help me
    Thank you very much for your precious time
    It's a good idea
    I'm going to try
    Cordially
    MARTI
    thank you.jpg

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Please how to create a digital clock

    You're welocme. Thanks for the feedback and for the rep. points
    Please mark the thread as solved
    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Digital Time Clock
    By tapsmiled in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-05-2015, 04:14 PM
  2. Digital clock - Date & Time type Needed
    By JJFletcher in forum Excel General
    Replies: 10
    Last Post: 10-17-2014, 12:46 PM
  3. Need a Digital clock in Excel
    By neckbone30 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 01:11 PM
  4. Digital clock on excel
    By shilpz in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-13-2012, 12:15 PM
  5. Digital Alarm Clock
    By cascao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 05:55 AM
  6. Digital Alarm Clock
    By cascao in forum Excel General
    Replies: 1
    Last Post: 06-07-2012, 04:19 AM
  7. Timer in cell (digital clock)
    By most_lost in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-18-2012, 01:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1