-
VBA progress bar help
Hi guys,
i am stuck trying to figure out how i can make my progress bar progress depending on the number of entry.
There are 14 inputs that when all of them are filled the progress bar should show 100%.
The way i have set the progress bar up is with a frame and a image that is getting dragged with the .width
Also it needs to be able to subtract, lets say i have 14 fields filled the progress bar is at 100% but if i make one field blank it should go down to 90% or its equivalent number.
-
And the user should switch every time from looking at the active cell to the statusbar ?
You want to drive them crazy ?
Please, do not upload pictures in this forum but Excel files instead.
Last edited by snb; 06-05-2020 at 01:58 AM.
-
This is not something that the operator is going to fill inn quickly. It is used registre and calculate the brakingpoint of lumber in a factory.
It is ment to give a Quick visual feedback so they can see from a distance how they are doing.
They might input a value, then go operate a machine to get one of the other values.
Sorry about the picture?
I mean there is no code for this as my question is more of a "where do i start coding this/ how should i think" , not "how do i code this" question.
-
There's a selection to check on Andy Pope's site
https://www.andypope.info/vba/pmeter.htm
-
Thank you!
That was very helpful, i should be able to convert some of that code into my workbook
again, thanks!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules