+ Reply to Thread
Results 1 to 12 of 12

Progress Bar Down from Existing Progress Bar Up

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

    Thumbs up Progress Bar Down from Existing Progress Bar Up

    Hi Guys,

    I have been tried to bring it down the progress bar from up, but finally i need your golden hands.
    The best way to explain it, please see directly on the file attachment.
    Hence i just wanna make summaries about my files:
    1. Progress Bar Init. : this is initial value of progress bar (before increasing on the next).
    2. Progress Bar Up : this is increasing from the Progress Bar Init.
    3. Progress Bar Dwn1 : I would like bring it down from Progress Bar Up to Progress Bar Init. (the target is the height should be same), but unfortunately i could not though i put with the same value decrements.
    4. Progress Bar Dwn2 : I would like to bring it down from Progess Bar Dwn1 to initial Bar (Label2, Height = 1), but i got debug.

    How to bring it down the progress bar (vertical) gradually?
    I made same value while progressing up and down, but the result shown different.
    Any helps from all of you guys, i am really...really appreciated.

    Thanks and Best Regards,
    Iqbal
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Iqbal,

    The percent value for that last call is negative replacing with
    Please Login or Register  to view this content.
    allows it to run
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

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

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi xladept,

    I was changed the code as your advice and the result is not showing to 0% (if i can say the progress bar in percentage, 0% = Height.value: 1) but it is increasing to more than 100% (while Progress bar Up, Run).
    And also, why the result is show different (progress bar dwn1, the height it is supposed to be same with the; progress bar init., but it's shown less height than progress bar init.) even though i put with the same val increment/decrements?
    Mr Orrin White, I am really thanks to you.

    Best Regards,
    Iqbal

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Iqbal,

    You're welcome, but I didn't immerse myself in your code. I'm not sure that I can - maybe I'll try again tomorrow, but I can't promise anything

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

    Re: Progress Bar Down from Existing Progress Bar Up

    Dear Mr Orrin White,

    For any small helps from you, again thank you so much.
    The God will blessing you and your family. Amen.

    Best Regards,
    Iqbal

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Iqbal,

    I don't yet understand what you're trying to do but give this a try and let me know whether it's any better than before:Iqbal.xlsm

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

    Re: Progress Bar Down from Existing Progress Bar Up

    Dear Mr Orrin,

    I am sorry to late reply.
    I would like to increasing the label up and to decreasing label down, this is my target. Please find the attach document. And i used the formula as your advice. Thanks a lot for the code.
    I put all constants with the same value (increments or decrements) and i am expecting the label increasing or decreasing smoothly as i drawn in the drawing, but the results is different when decreasing.
    Mr Orrin, again thank you so much for your golden hands.

    Best Regards,
    Iqbal
    Attached Files Attached Files
    Last edited by iqballud; 07-01-2014 at 05:01 AM.

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool


    Hi !

    Try buttons in this attached sample workbook Progression .xls !

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

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Marc,

    I was opened your files and that's looking good, but i am working with the constants data for increments/decrements and your code base on timer.
    Thanks a lot for your contribution to solve my problem, highly appreciated to you Marc.

    Best Regards,
    Iqbal

  10. #10
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Progress Bar Down from Existing Progress Bar Up


    My code increments / decrements isn't based on timer !

    Timer is only used to perform a micro pause after each phase reaches 100% …
    Last edited by Marc L; 07-01-2014 at 06:04 PM.

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

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Marc.
    Thank you for your correction.
    Maybe next post i will ask how to create progress bar horizontal base on timer.

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Progress Bar Down from Existing Progress Bar Up

    Hi Iqbal,

    Thanks for the rep! Shall I take another look or have you resolved your issue?

+ 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. how to add a progress bar in existing macro?
    By athlug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-21-2014, 11:45 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. Adding Progress Bar to existing Macro...
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 04:32 PM
  5. [SOLVED] NEED Help - How to capture the Event's progress in Progress Bar
    By Sriram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2006, 07: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