Good morning forum
I would like some assistance with a project I am planning using progress bars, background as follows:
Currently using excel 2010:
Windows 7:
Programming Standard: Novice.
Project: I would like to use a number of progress bars to track steps in a project. Each step takes a different time to complete, however I would like to be able to click a user control if the task has completed before time.
I appreciate this is not a trivial task, however I would appreciate a starting point. I want to display the current time as the start point and update the time display and progress bars every 30 seconds. So I think it looks something like this
Display Current time: 12:18 ' Display currnt time and update every 30 seconds
Progress Bar TaskA (5minutes) ----> Progress Bar TaskB (3 minutes)
When TaskA completes (or the control is selected) TaskB starts. If TaskA does not complete in 5 minutes the progress bar turns red and TaskB does not start until the user control on Task A is selected.
I can do all the userforms stuff myself I just need a hand with is using the system time to driving and updated a progress bar and as each progress bar completes the next one starts.
Hope you can give me a starting point or request more detail on what I am trying to achieve.
Many thanks
Best regards
Rob
I would like some assistance with a project I am planning using progress bars, background as follows:
Currently using excel 2010:
Windows 7:
Programming Standard: Novice.
Project: I would like to use a number of progress bars to track steps in a project. Each step takes a different time to complete, however I would like to be able to click a user control if the task has completed before time.
I appreciate this is not a trivial task, however I would appreciate a starting point. I want to display the current time as the start point and update the time display and progress bars every 30 seconds. So I think it looks something like this
Display Current time: 12:18 ' Display currnt time and update every 30 seconds
Progress Bar TaskA (5minutes) ----> Progress Bar TaskB (3 minutes)
When TaskA completes (or the control is selected) TaskB starts. If TaskA does not complete in 5 minutes the progress bar turns red and TaskB does not start until the user control on Task A is selected.
I can do all the userforms stuff myself I just need a hand with is using the system time to driving and updated a progress bar and as each progress bar completes the next one starts.
Hope you can give me a starting point or request more detail on what I am trying to achieve.
Many thanks
Best regards
Rob