+ Reply to Thread
Results 1 to 9 of 9

Progress bar in userform

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Progress bar in userform

    Hello

    I would like to have a progress bar in some of my userforms.

    As an example i attach a sample.

    Thanks in advance for any assistance here!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Re: Progress bar in userform

    What progress do you want to monitor...?

    The sample user form is a data entry/search (didn't take the time to look) form, there's no progress to report, is there?

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Progress bar in userform

    Thanks for looking at this.

    In my example the confirm button transfer data of userform to the second sheet.

    I'd like to monitor this progress.

  4. #4
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Re: Progress bar in userform

    Please Login or Register  to view this content.
    Updating 5 cells in a loop that iterates once is not something that needs a progress bar... in my opinion. You're adding needless complication/overhead to something that is practically instantaneous.

  5. #5
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Progress bar in userform

    Thank you very much for your advices.

    As i said in my first post..

    .. would like to have a progress bar in some of my userforms.

    As an example i attach a sample.
    I have many codes that take many seconds to run. So i need this progress bar for these codes.

    So do you have any idea for how a progress bar could works in my example?

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Progress bar in userform

    You change its value:

    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.

  7. #7
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Progress bar in userform

    Yes this works. Thank you.

    Altrough i don't understand what do you mean when you say: "You change its value"

    Also if you don't mind, may i ask this?

    Will always use the same criteria? I mean that in my code there are 6 different trandfer so you used 6 different levels for the progreessing bar. So is this the way that i have to use when i use a progress bar?

  8. #8
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Progress bar in userform

    I mean you change its value using code like this:
    Please Login or Register  to view this content.
    You will need to work out what the value should be based on how many steps you have to perform, and how many you have completed.

  9. #9
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Progress bar in userform

    I believe that i get the logic!

    Thank you very much.

+ 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. First attempt at UserForm progress bar. Bar not updating.
    By mvparker79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2014, 03:18 PM
  2. Progress bar for loading Userform
    By idinuv in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-22-2014, 11:15 AM
  3. 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
  4. connecting progress bar to ok button on userform
    By samz93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 05:40 AM
  5. Progress bar using the userform/module method
    By pato225 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 09:44 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