How to create a static progress bar that is fixed and responds to user input manually

[chin67326]

The attached workbook opens a userform with three textboxes and three labels. I want to be able to enter a number from 1 to 100 in the textbox and the label should change from its fully grey color to the
corresponding shade of yellow as per the number entered in the textbox. An example is in the picture below.

staticbar.jpg

Essentially the purpose is to have more or less a static progress bar, where one can update the number progress in the textbox and the label will update as a result and one can then use his code to save the
data values in the usual way.

Are you able to assist with the coding to update the label after the textbox value has been changed?

Thanks!

[Richard Buttrey]

Hi,

Use the text box change event. e.g.

Please Login or Register  to view this content.

[Keebellah]

Or try this
I set the imax to 100 in the userfrom's vba

[chin67326]

Thanks Richard Buttrey and Hans; both are simply amazing solutions!

Hans, any chance for there to be no progress showing at 0%? I ask because at zero there is a little small red bar present under the 0%.

[Keebellah]

You can cahnge the label width to 0 or add the follwoing code the userform's VBA

Please Login or Register  to view this content.

[chin67326]

You can cahnge the label width to 0 or add the follwoing code the userform's VBA

Please Login or Register  to view this content.

Very well! Great solutions from great minds!

[Keebellah]

Just some fine tuning

[chin67326]

Just some fine tuning

Good adjustments

Thanks.