+ Reply to Thread
Results 1 to 7 of 7

Label as Progress Based On Timer

  1. #1
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Post Label as Progress Based On Timer

    Hi Guys,

    I have this code to display the progress of timer, but this code not actually timer that i can set the time value.
    The time value based on "..Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)".
    Does anyone to help me how to create the Label Progress based on Timer, please?
    I attached the file as your reference.

    This code under module1:
    Please Login or Register  to view this content.
    And this code under UserForm1:
    Please Login or Register  to view this content.
    Thanks in advance and appreciated to all of you for your helps.

    Regards,
    Iqbal
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Label as Progress Based On Timer

    Try:
    Please Login or Register  to view this content.
    As you can see, besides key correction
    intMax = Int(Val(UserForm1.TextBox1.Value) * 60 * 5),
    I made minor correction to sleep time and some play with colors.
    IMHO if you want it for minutes, then Aplication.onTime event (accuracy in seconds) would be worth considering instead of Sleep.
    Last edited by Kaper; 07-29-2014 at 04:23 AM.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Label as Progress Based On Timer

    hi Kaper,
    Thank you so much for your code, but when i was installed the code, the code is not working.
    I attached the file back as your reference with your code.
    Kaper, I am sorry for late reply.
    I am almost despairing to wait for someone will help to solved this code.
    Finally i got the guys with the golden hands like you.
    Again thank you so much Kaper.

    Best Regards,
    Iqbal
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Label as Progress Based On Timer

    I probably do not understand you, but may be ... aside from progress bar you want something in Label 3? then write it (what you want) in label3 caption - like
    Please Login or Register  to view this content.
    other proposition in attached file.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Label as Progress Based On Timer

    My aim is simple, i want the progress timer will be shown by label.
    lets say the width of label, width = 72 and timer setting = 3 minute.
    The progress timer while counting up will be showing by label.

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Label as Progress Based On Timer

    IMHO post #4 attachement does it.

  7. #7
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Label as Progress Based On Timer

    Hi Kaper,

    I got it now. I am created the code based on your idea, post#4.
    Thank you so much Kaper.

    Regards,
    Iqbal

  8. #8
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Label as Progress Based On Timer

    Hi Kaper,

    I got it now. I am created the code based on your idea, post#4.
    Thank you so much Kaper.

    Regards,
    Iqbal

+ 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. Progress bar Based on data Loading
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 06:28 AM
  2. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-08-2014, 02:40 AM
  3. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 12:41 PM
  4. VBA Timer in Label
    By skip2mylew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 07:30 PM
  5. Replies: 1
    Last Post: 12-12-2012, 08:46 PM

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