"drawlings" wrote
in message ...

Thanks for your replys, but I would like to make the change on the fly
since I am using the label as a progressbar.


You can change almost any property, that's not the point.
I was puzzled by "colour fading". I was thinking of gradient colour. But if
you need a progressbar, then 2 colours would do, right?
Here is an idea:

I assume that you want to put your progress bar on a UserForm. You need 3
labels:
1 label, width as desired for the progress bar, background color white, no
text

now put a copy of this label on top of it. For this second label change
properties:
initial width zero, background colour blue, no text (you guessed it, this
will become your progress bar)

On top of the whole thing place a centered text (another label)

According to progress of whatever your code is doing your code must change
the width of the blue label and the contents of the text label.
I haven't tested it, but it should work.

Cheers,

Joerg