fashing/blinking form label

[aspnetuser]

Hello.

Is it possible to loop a label flashing "p r o c e s s i n g" for the duration of a long code execute in excel vba form?

if so could i see or have the snippet?

i am not sure how to do it. my label name is lblFlashin.

thanks,
regards.

 

[RogADog]

If you take a look here:

http://www.j-walk.com/ss/excel/eee/eee002.txt

you will find some code to make an Excel cell blink. You could use the same method to make a control on a form appear to flash but you will need to include a 'DoEvents' in the loop.

Hope it helps

Rog